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.
- 4 Answers
- 8564 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ankur saini er.ankur861@gmail.
hi...i think this cannt be done without an audit columns ..
a date or batch id etc..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is meant by LDAP users?
list out all the transformations which use cache?
Explain how to import oracle sequence into informatica?
How many ways are there to create ports?
what are 3 tech challenges/ common issues you face?
How to load a Dimension ? and how to load a fact table?
If informatica has its scheduler why using third party scheduler?
How many transformations can be used in mapplets.
What is a passive transformation?
What is the difference between Active and Passive transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
In informatics server which files are created during the session rums?
How do you set a varible in incremental aggregation
Define update strategy?
