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
- 19015 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sanjay
While loading the flat file target integration service do not have to prepare insert/update/delete sql statements, also there should not be any database overhead like unique index validation or constraints checking for the target data and no auto data type conversion takes place while writing to flat file target.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is informatica metadata and where is it stored?
What do you understand by a term domain?
What is the sql query overwrite in source qualifier in informatica
How many numbers of sessions can one group in batches?
How union transformation is used?
What do you mean by worklet?
Differentiate between sessions and batches?
Can u generate reports in Informatica?
How can we delete duplicate rows from flat files?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
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?
Explain transaction control transformation in informatica
Describe an informatica powercenter?
On which transformations you created partitions in your project?
