Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
- 11 Answers
- 16394 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Briefly explain the aggregator transformation?
What do you understand by term role-playing dimension?
Can we get 1st record through Informatica(without sequence number).
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain the types of lookup transformation?
Briefly define a session task?
draw informatica architecture 8.6 ?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Explain the different kinds of facts.
How does the aggregator transformation handle null values?
What is the maplet?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
COM components can be used in Informatica
