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

Answer Posted / abhinav

I guess the question was wrong as you cannot update a flat file as target.
In a Flat file data can only be inserted not updated.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you use flat files in Mapplets.

2209


what are the Methods For Creating Reusable Transformations?

640


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1546


Explain lookup transformation is active in informatica

650


Explain the mapping variable usage example in informatica

624






how to load rows into fact table in data warehouse

630


In informatics server which files are created during the session rums?

622


How do you load only null records into target? Explain through mapping flow.

1488


Write the unconnected lookup syntax?

646


What is update strategy transform?

558


Why do we need informatica?

547


update strategy transformation in informatica

628


Target increases every day even though no new record was inserted

1098


What is an active transformation?

638


What is the difference between Active and Passive transformation?

626