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
How does a rank transform differ from aggregator transform functions max and min?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Which transformation is needed while using the Cobol sources as source definitions?
What is rank transformation?
Define sessions in informatica etl?
What is union transformation?
In how many ways we can create ports?
What is the command used to run a batch?
what are the deliverables?in your project?
What is the maplet?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Describe data concatenation?
Why sorter is an active transformation?
scenario where i can use only concurrent execution of workflow.