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
what is the hint? how to use it to reduce the query processing in program?
How to use pmcmd utility command?
what is index?how it can work in informatica
What is InformaticaPowerCenter?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the uses of etl tools?
how many types of dimensions are available in informatica?
What is a grid in Informatica?
what are the deliverables?in your project?
How can we use batches?
What are the advantages of using informatica as an etl tool over teradata?
How can you differentiate between powercenter and power map?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?