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 / 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 informatica? Why do we need it?
What is decode in static cache?
In warehouses how many schemas are there?
Explain the aggregator transformation?
COM components can be used in Informatica
Why sorter is an active transformation?
server hot-ws270 is connect to Repository B. What does it mean?
Explian the Process of deployment groups in informatica
What is meant by LDAP users?
What are the features of complex mapping?
What are the databases that informatica can connect to windows?
What is Data Caches size?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Define mapping and session?