How can we load the flat file

How can i load a flat file into target as fast as i can?Assuming that the source bottleneck is not there,that is there is no performance issues in the source side.

Questions by etl_bhargavi

Showing Answers 1 - 3 of 3 Answers

nikhilanshuman

  • Dec 18th, 2010
 

A Flat file can be read using sequential file stage.To make data load faster,try implementing least stages in you job and use minimal transformations.if you are trying to load the data of a flat file into Oracle database,then select Truncate Load method in the OEE stage. and drop the indexes before loading the data.Once the load is finished,you can recreate the indexes.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions