Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / rayudu
another reason is that when we load the data into table
integration service also verifies data type and will do
parsing if needed. But in case of flat file there is no need
of parsing and checking data types.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is update strategy transform?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is a sorter transformation?
Mention few advantages of router transformation over filter transformation.
Performance tuning in UNIX for informatica mappings?
Why update strategy and union transformations are active?
How can we use batches?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Which is the t/r that builts only single cache memory?
Enterprise data warehouse your projects phase by phase explain?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What do you understand by SOA of Informatica?
Do you find any difficulty while working with flat files as source and target?
Clarify the utilization of aggregator cache record?
How can repository reports be accessed without sql or other transformations?