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 / alekya
use a mminus query between two tables..you will get the
mismatch records.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What all are steps in up gradation of Informatica server?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is informatica etl tool?
How are indexes created after completing the load process?
Tell me about Propagate functions in informatica
what are the deliverables?in your project?
Clarify the utilization of aggregator cache record?
differences between service based and product based?
What is Cognos script editor?
How do you change a non-reusable transformation to reusable transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explian the Process of deployment groups in informatica