While using update strategy in the mapping which gives more
performance, a flat file or Table? Why? What are the
advantages and disadvantages?

Answer Posted / kish`

hi,

update strategy never use for flatfiles....plz correct me,
if it is wrong

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we use mapping variables in informatica? Where do we use them?

825


How do you promote a non-reusable transformation to reusable transformation?

891


can u give example for factless fact table

5952


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1945


How to update or delete the rows in a target, which do not have key fields?

886


whats the logic to load the lower level of granularity of data to fact table.

2029


Different qualification between a related rotate toward the sky and isolates look upward?

760


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1771


What is a router transformation?

821


Write the different tools in the workflow manager?

769


where to store informatica rejected data? How to extract the informatica rejected data?

776


Can we get 1st record through Informatica(without sequence number).

1197


Explain the different dimensions.

729


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1359


Differentiate between router and filter transformation?

793