I guess the question was wrong as you cannot update a flat file as target.

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

Question Posted / abhinav

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

Please Help Members By Posting Answers For Below Questions

How do you handle two sessions in Informatica

1164

What is a snowflake schema?

994

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2057

What is expression transformation?

1099

What does refresh system mean, and what are its distinctive choice?

1179

How do you convert single row from source into three rows into target?

1157

What is the difference between a connected look up and unconnected lookup?

966

How many dimensions are there in informatica?

1085

In development project what is the process to follow for an etl developer from day1

1724

What are the measure objects?

1202

What are session parameters ? How do you set them?

1849

Differentiate between joiner and lookup transformation?

1102

What does command task mean?

1145

How you know when to use a static cache and dynamic cache in lookup transformation?

1854

What is update strategy transform?

1101