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
- 8567 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 is curr val use for in sequence generator?
What is the use of source qualifier?
What is active and passive transformation?
what is mapping override?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
select count(1) from emp? what is the o/p?
How to differentiate between the active and passive transformations?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
What is a candidate key?
What exactly mentioned in High level design document.can somebody explain me sequentialy.
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
Teradata 
