with out using update strategy transnsformation how to
update the data in mapping level

Answer Posted / guest

By using target update override and by using sessions
property treat source rows as update.by using this options
we can update the data
If any statement is wrong try to correct it

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

840


What is update strategy transform?

798


What are some examples of informatica etl programs?

729


Suppose we do not group by on any ports of the aggregator what will be the output?

805


what is size of u r database?

2028


What is a joiner transformation and why it is an active one?

765


What does command task mean?

797


Explain the shared cache and re-cache?

809


What is a transaction control transformation?

958


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1721


Can we change Dynamic to Static or Persistent cache? If so what happens?

1926


What are the new features of Power Center 5.0?

1427


What is DR strategy for Informatica project?

902


Can we create multiple integration service on single repository?

940


What are connected or unconnected transformations?

861