Interested to Buy Any Domain ? << Click Here >> for more details...
Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
- 11 Answers
- 19036 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rayudu
hi,
Flat file doesn't contain any indexes or keys so it will
directly load into it. whereas in a table it will first
check for indexes and keys while loading into table so it is
slow when compared to flat file loading.
Regards,
rayudu.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Clarify the aggregator change?
How can you define user defied event?
Tell me about Propagate functions in informatica
in reporting we add some new objects,how we get the count of the newly added objects to the report
Define Pmrep command?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the limitations of joiner transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Why do we need informatica?
what is unit testing?tell me proceedure
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Write the unconnected lookup syntax?
What is a node in Informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
