Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / ankur saini er.ankur861@gmail.
Hi in case of teradata..IS have to take care of database
logs , and backup tables etc like transient journel etc
which makes it slow in case of table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Quickly characterize reusable change?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How to Create a folder using pmrep command?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Is it possible to revert a global repository to local one and why?
What is a sorter transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is incremental aggregation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What will be the approach?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Partition, what happens if the specified key range is shorter and longer
Differentiate between Load Manager and DTM?
Which are the different editions of informatica powercenter that are available?
On which transformations you created partitions in your project?