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 is meant by query override?
What is rank transformation in informatica
Explain scd type 3 through mapping.
What does update strategy mean, and what are the different option of it?
What is workflow manager?
What is native users?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Please let me know how to make Data masking in informatica..
What is meant by pre and post session shell command?
How to start a workflow using pmcmd command?
What is the cumulative sum and moving sum?
How to update a particular record in target with out running whole workflow?
What is the sequence generator transformation in informatica?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Explain load alternative records / rows into multiple targets - informatica