Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / ranjan
One more answer is in general flat files are kept on the server where informatica is installed.Thats the reason flat file loading is faster.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are Dimensional table?
How would you copy the content of one repository to another repository?
What is a dimensional model?
Explain incremental aggregation in informatica
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Enlist some properties of sessions.
What is the cumulative sum and moving sum?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
what is index?how it can work in informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Partition, what happens if the specified key range is shorter and longer
What do think which one is the better joiner or look up?
In informatics server which files are created during the session rums?
Explain where to store informatica rejected data? How to extract the informatica rejected data?