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
How can one identify whether mapping is correct or not without connecting session?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
r u done any partitions in ur project?
How can you define user defied event?
What is the maplet?
What is sequence generator transformation in informatica?
What are connected or unconnected transformations?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
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.
What are ETL Tools?
Explain the different dimensions.
How union transformation is used?
What is status code in informatica?
Explain the tuning lookup transformation - informatica
What are batches?