In update strategy target table or flat file which gives
more performance ? why?

Answer Posted / sriram

Update strategy can be performed on tables not on Flat files.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

wat are deployement groups in informatica, how it will be used for developers

1244


What is the Rank index port in Rank transformation?

663


how we can load rejected record's at run time?(not through bad files)

1901


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4764


Design a mapping to load a target table with the following values from the above source?

867






What is the meaning of decode in informatica?

639


How can we create index after completion of load process?

587


whats the logic to load the lower level of granularity of data to fact table.

1789


What is lookup change?

610


What is a dimensional model?

572


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1743


What is the difference between router and filter?

637


What is workflow? What are the components of workflow manager?

698


What is blocking transformation?

705


Differences between version 7.x and 8.x.

1407