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

What is a passive transformation?

646


Enlist the tasks for which source qualifier transformation is used.

593


Define the various join types of joiner transformation?

561


In warehouses how many schemas are there?

585


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1655






What are the static cache and dynamic cache in informatica?

721


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1612


Why union transformation is an active transformation?

659


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1020


What does “tail –f” command do and what is its use as an Informatica admin.

635


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

702


what are 3 tech challenges/ common issues you face?

1893


What is mapplet in informatica?

598


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1861


Write the prerequisite tasks to achieve the session partition?

654