Which is faster in informatica? Flat file to database or database to database

Get new comments by email
You can cancel email alerts at anytime.
Comments (5)

kiran in Cincinnati, Ohio

84 months ago

Which load is faster in informatica? loading data from flat file to oracle schema.
Or oracle table to another oracle table.

- Was this comment helpful? Yes / No Reply - Report abuse

hari in Naperville, Illinois

83 months ago

flat file to oracle would be faster

- Was this comment helpful? Yes (6) / No (6) Reply - Report abuse

Rajeshkumar in Stamford, Connecticut

75 months ago

In addition to above answer , some more scenarios as well support..

loading data directly from DB Tables and TGT desgined without key or constraint..perform bulk load u will get result faster.

as well as both src and tgt flat file load on local server example trying to load both on local server directory instead off ftp will also bring result faster.

- Was this comment helpful? Yes (2) / No Reply - Report abuse

shiva

61 months ago

how to load a flat file data into another flat file using informatica tool..??
plz help me out from this as soon as possible...???

- Was this comment helpful? Yes (1) / No Reply - Report abuse

Anil in Overland Park, Kansas

54 months ago

@kiran: It all depends on the scenario....If you have a well tuned DB and a partitioned table structure, then you can load from one table to other table wayyyyy quicker than a flat file sitting on the network. You can use push-down optimization in that scenario which helps to quicken the load. On the contrary, if the flat file is sitting on the Informatica box then it would load faster than the table. You can use BULK loading and finish the task quicker. So in the end you have to see the scenario and go for a trial and error method. Hope it helps.

@shiva: It is simple....You will have the source and target defined as a Flat file !!!

- Was this comment helpful? Yes / No Reply - Report abuse

» Sign in or create an account to comment on this topic.