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
- 8934 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / alekya
use a mminus query between two tables..you will get the
mismatch records.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / hollister
The key coluns that are common in both tables are to be
considered and compare each field in both tables. If there
is any change in any of the column in table B then it is
the updated column.
| Is This Answer Correct ? | 0 Yes | 10 No |
What are the data movement modes in informatcia?
What are Business Components in Informatica?
diffrence between command task and control task
What is the difference between SOURCE and TARGET BASED COMMITS?
How to load the data from a flat file into the target where the source flat file name changes daily?
Describe the impact of several join conditions and join order in a joiner transformation?
In warehouses how many schemas are there?
What are the out put files that the informatica server creates during the session running?
How to send duplicates to one target and unique rows to one target?target is empty
Can we get 1st record through Informatica(without sequence number).
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what is $$$$?
Teradata 
