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

How can one identify whether mapping is correct or not without connecting session?

1174


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

938


r u done any partitions in ur project?

1594


How can you define user defied event?

843


What is the maplet?

835


What is sequence generator transformation in informatica?

848


What are connected or unconnected transformations?

883


Name at least 5 different types of transformations used in mapping design and state the use of each.?

919


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2555


What are ETL Tools?

871


Explain the different dimensions.

756


How union transformation is used?

805


What is status code in informatica?

808


Explain the tuning lookup transformation - informatica

804


What are batches?

827