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

Answer Posted / sanjay

Flate file give better performance bcz Retrival of data
from flat file is fast then relation database

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which version configuration tool used in ur project?

2758


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10265


What is pmcmd command?

661


When do you use sql override in a lookup transformation?

575


What is an expression transformation?

582






what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1764


Explain the types of lookup transformation?

551


Define joiner transformation?

582


What do think which one is the better joiner or look up?

709


What is aggregator transformation in informatica?

532


What are the advantages of informatica?

562


How to load data in informatica ?

558


how tokens will generate?

1722


Mention few power centre client applications with their basic purpose?

525


Explain sessions. Explain how batches are used to combine executions?

583