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 are the informatica performance improvement tips
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Enlist the differences between database and data warehouse.
Explain dynamic target flat file name generation in informatica
Define filter transformation?
What is dimensional table?
explan ur project architecture?
can u any challenge your project?
What is a node in Informatica?
How to elaborate powercenter integration service?
What is rank transformation in informatica
Clarify the aggregator change?
What is domain and gateway node?
explain one complex mapping with logic? sales project?
What are the different clients of powercenter?