Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / suresh
Here the records has to pass through the database drivers and ODBC connections are required, which is a time taking process.
But where as records from flat files are copied in easier way
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is data transformation manager process?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is the procedure for creating independent data marts from informatica 7.1?
Explain about cumulative Sum or moving sum?
What is informatica etl tool?
How can you validate all mappings in the repository simultaneously?
What does refresh system mean, and what are its distinctive choice?
Briefly explain the aggregator transformation?
What are the limitations of joiner transformation?
What are the components of the workflow manager?
What are the components of workflow manager?
Explain the difference between a data warehouse and a data mart?
What is mapplet in informatica?
What are the popular informatica products?