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 |
explain about session partitions ?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
Discuss the advantages & Disadvantages of star & snowflake schema?
What are the out put files that the informatica server creates during the session running?
what is diffrence b/w joner and union transfermation
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
What is the different lookup cache(s)?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
What is an aggregator transformation? it is active why cant it be passive explain?
What are parallel querys and query hints?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
Explain the difference between a data warehouse and a data mart?