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
- 8875 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 union transformation?
How we can create indexes after completing the loan process?
How do you migrate data from one environment to another?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the reusable transformation?
What are the modules in Power Center
What is a connected transformation?
can u give example for factless fact table
What are multi-group transformations?
What is aggregate cache in aggregator transformation?
What is lookup transformation?
What are the different transaction levels available in transaction control transformation?
How would you join a node to the already existing domain?
How to extract the informatica rejected data?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
