Question

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

  • 11 July 2019
  • 1 reply
  • 2 views

Badge

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

Badge

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.

Reply