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

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

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

Question Posted / guest

7 Answers
24685 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / naga

Flat file is better only for Insert,but if you are using
Update strategy for updating a table and also we a Flat
file cannot be updated

Is This Answer Correct ?

7 Yes

2 No

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

Answer / naga

Flat file is better only for Insert,but if you are using
Update strategy for updating a table then table gives
better performance and FYI a Flatfile cannot be updated

Is This Answer Correct ?

9 Yes

4 No

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

Answer / sriram

Update strategy can be performed on tables not on Flat files.

Is This Answer Correct ?

1 Yes

0 No

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

Answer / nishtha

Can someone pls give correct answer for this question?

Is This Answer Correct ?

0 Yes

0 No

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

Answer / nagaraju

flat file is better than relational becoz there is no index concet in flat file

Is This Answer Correct ?

1 Yes

1 No

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

Answer / 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