In update strategy target table or flat file which gives
more performance ? why?
Answer Posted / naga
Flat file is better only for Insert,but if you are using
Update strategy for updating a table and also we a Flat
file cannot be updated
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is decode in static cache?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
without table how to come first record only in oracle?
How can we remove the duplicates from flat file source?
What does refresh system mean, and what are its distinctive choice?
Is there any way to read the ms excel datas directly into informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How many numbers of sessions can one group in batches?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to improve the performance of a session using sorter transformation?
Write the different tools in the workflow manager?
What is union transformation in informatica?
what are the Methods For Creating Reusable Transformations?
Describe an informatica powercenter?