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 will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain what are the different versions of informatica?
What do you mean by channel change?
How would you copy the content of one repository to another repository?
explan ur project architecture?
How to join three sources using joiner? Explain though mapping flow.
Explain why we use partitioning the session in informatica?
How to update or delete the rows in a target, which do not have key fields?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are data-driven sessions?
What is workflow? What are the components of workflow manager?
What is the way to execute pl/sql script using informatica mapping?
How we can create indexes after completing the loan process?