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!
+18Depending on the FME version, you should be able to disable feature caching from the menu.
+22Once 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
