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 then table gives
better performance and FYI a Flatfile cannot be updated
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How are indexes created after completing the load process?
What is the cumulative sum and moving sum?
How to create Target definition for flat files?
How to load last n records of file into target table - informatica
How can we handle two sessions in informatica?
what are the deliverables?in your project?
Explain what transformation and how many are there in informatica?
What is rank transform?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain why we use partitioning the session in informatica?
What is rank index in rank transformation?
What is a repository? And how to add it in an informatica client?
If informatica has its scheduler why using third party scheduler?
How do you convert single row from source into three rows into target?