Skip to main content
Question

How to Split the attributes based on count and insert it into Oracle

  • July 11, 2019
  • 1 reply
  • 36 views

Forum|alt.badge.img

I have FGDB file with 200 attributes. But i want to split the parts and insert them into oracle table.

Split 1 : First 70 (1-70)insert into oracle.

Split 2: Second 60 (70-130) records insert into oracle.

Split 3: remaining all are insert into oracle.Here the oracle tables are different.

 

I need the suitable solution for this.How can i do this by using FME workbench. In real time data there are lacks of records are there we need to insert step by step.

1 reply

Forum|alt.badge.img
  • July 11, 2019

Do you mean 200 records or 200 attributes? If it's 200 records, then you can use a Counter on your source data and then split it to three different destinations in a TestFilter according to the count attribute. Count<70, count>130, Else.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings