can v update d records in target using update stargey
without generationg primary key ? explain

Answer Posted / leo gilbert

By using "Update override" option in the target. Say the
key of your table is ID,NAME. But your mapping is passing
only ID to the target then you can have an update override
query in the target to update the target only based on
ID.

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1755


Explain pushdown optimization and types in informatica

668


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

556


Explain direct and indirect flat file loading (source file type) - informatica

834


How do you set a varible in incremental aggregation

1449






How many ways are there to create ports?

730


Define joiner transformation?

596


Design a mapping to load a target table with the following values from the above source?

880


What are the new features of informatica 9.x in developer level?

563


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1871


What is update strategy transform?

576


In informatica workflow manager, how many repositories can be created?

782


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1917


How to configure mapping in informatica?

674


What is the use of transformation?

576