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 / hollister
The key coluns that are common in both tables are to be
considered and compare each field in both tables. If there
is any change in any of the column in table B then it is
the updated column.
| Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
What does command task mean?
Is it possible to use a client with different version than that of its Informatica server?
COM components can be used in Informatica
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
what is song in infrmatica...?
define galaxy repository in informatica
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Which transformation is needed while using the Cobol sources as source definitions?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Is there any way to read the ms excel datas directly into informatica?
can anyone suggest best free Talend data integration training online
What is a predefined event?
What is the use of transformation?
What are the tasks that can be performed using sq?
Informatica Checkpoints