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
server hot-ws270 is connect to Repository B. What does it mean?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can we store previous session logs?
Tell me about Propagate functions in informatica
Write the advantages of partitioning a session?
What are the types of lookup transformation?
What are active and passive transformations?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
write a query to retrieve the latest records from the table sorted by version(scd)
How can you increase the performance in joiner transformation?
What is the cumulative sum and moving sum?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How many ways a relational source definition can be updated and what are they?
What are the types of schemas we have in data warehouse and what are the difference between them?
How to delete duplicate row using informatica?