While using update strategy in the mapping which gives more
performance, a flat file or Table? Why? What are the
advantages and disadvantages?

Answer Posted / krish

flat file
bcz no connections needed no network busy etc;

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2293


What is the meaning of up gradation of repository?

1387


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1547


What is the difference between a repository server and a powerhouse?

801


Mention a few design and development best practices for informatica?

555






What do you mean by enterprise data warehousing?

634


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

553


How to load a Dimension ? and how to load a fact table?

949


What is difference between a gateway node and worker node?

615


How to start a workflow using pmcmd command?

707


explain abt ur project architecture?

1758


What are the new features of informatica 9.x developer?

528


Mention some types of transformation?

602


What is an Integration service in Informatica?

699


What is target designer and target load order?

652