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.
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 |
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
what is difference between dimention table and fact table?
Different qualification between a related rotate toward the sky and isolates look upward?
What is surrogate key?
What are the types of maping in Getting Started Wizard?
How to convert multiple rows to single row (multiple columns) in informatica
Why we select the table which has minimum number of records as Master table in joiner?
In warehouses how many schemas are there?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
how to connect two or more table with single source qualifier?
how i will stop my workflow after 10 errors