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 do you load alternate records into different tables through mapping flow?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the use of target designer?
How to handle decimal places while importing a flatfile into informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is different between the data warehouse and data mart?
What is a difference between complete, stop and abort?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are junk dimensions?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Global and Local shortcuts. Advantages.
Performance tuning in UNIX for informatica mappings?
Differentiate between a database and data warehouse?
What are the various types of transformation?