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
- 18647 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nidhi
To write data in table informatica server generate the insert statement for each row where as for flat file write the data row wise in file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
write a query to retrieve the latest records from the table sorted by version(scd)
What is the function of look up transformation?
What is the scenario which compels informatica server to reject files?
What do you mean by enterprise data warehousing?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
expain about the tune parameters?
How to improve the performance of a session using sorter transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What does role playing dimension mean?
What does refresh system mean, and what are its distinctive choice?
server hot-ws270 is connect to Repository B. What does it mean?
How can repository reports be accessed without sql or other transformations?
What do you understand by term role-playing dimension?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
