source table A having 100000 records. and target B table
having 100000 records. now iam updating B records using update
query. i don't know which record is update in target. write a
sql query get all updated records from target table B.
Answer Posted / alekya
use a mminus query between two tables..you will get the
mismatch records.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to update or delete the rows in a target, which do not have key fields?
What are the different types of repositories created using informatica?
Can we create a Integration service without a Repository service and vice versa?
How to create the source and target database connections in server manager?
What are the types of lookup transformation?
How can informatica be used for an organization?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is persistent lookup cache?
What is a code page?
How to use procedural logic inside infromatica?
Explain how many types of dimensions are available in informatica?
What is a router transformation?
What is confirmed fact in dataware housing?
Explain pushdown optimization $pushdownconfig parameter - informatica