Skip to main content
  • EN

Hello Friends,

 

Since I am learning new transformations and new to FME tool. Could someone please guide me how to load a data from one table to another ( 100% dump)? which transformation to use? I use SQL executor when I wrote Select * from table1 and mapped result output to Writer.

 

Is there any other way? Thank you in advance!

 

I have used above two transformations but it took 5 mins to load 280K rows. Can I make it faster by using different transformation?

 

See below..

 

Also, the transaction Log says.. " Feature caches have been recorded at every state of the translation"

Is this slowing down the process? can I disable this feature? if yes, How to fix it?

 

Thank you!

Depending on the FME version, you should be able to disable feature caching from the menu.

Once you are more comfortable with the tool and if you are going to do that with many tables, you should check the Dynamic Workflows:

 

 

https://knowledge.safe.com/articles/1050/dynamic-workflow-tutorial-introduction.html

Once you are more comfortable with the tool and if you are going to do that with many tables, you should check the Dynamic Workflows:

 

 

https://knowledge.safe.com/articles/1050/dynamic-workflow-tutorial-introduction.html

Hi Oscard, Thank you for replying. I have a source table in One Oracle DB and Target table is already created in another oracle db. I just need to dump data from source to target. I just did below but features ( records) are not being inserted in target table. Could you please help me here? what am I doing wrong? Also, I don't see the columns names for Target table, the same I see in source. please help? Thank you.

 

 

 

Depending on the FME version, you should be able to disable feature caching from the menu.

Thank you Itay for replying. I have a different version of FME installed but I was able to find it how to disable it.

Once you are more comfortable with the tool and if you are going to do that with many tables, you should check the Dynamic Workflows:

 

 

https://knowledge.safe.com/articles/1050/dynamic-workflow-tutorial-introduction.html
Also, the ultimate goal is to load data from A.table1 to B.table2 ( from table in schema A to table in schema 😎. Both schema & table name are different in different database ( both oracle) though.

Reply


Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.