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
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are active and passive transformations?
what is index?how it can work in informatica
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How can you differentiate between powercenter and power map?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Please let me know how to make encryption and decryption with example?
How many types of sessions are there in informatica.please explain them?
What are the tasks that can be performed using sq?
What is lookup change?
How can repository reports be accessed without sql or other transformations?
What is joiner change?
how many types of dimensions are available in informatica?
How to use procedural logic inside infromatica?
How might one distinguish in the case of mapping is right or not without associating session?