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
- 8827 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 |
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
disable caching in a lookup transformation?
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
Why we use ENABLE HIGH PRECISION in session properties?
What is fact table? Explain the different kinds of facts.
What are the components of workflow manager?
What is the difference between Bitmap and Btree index?
Is informatica power center designer has 64 bit support?
Explain sessions?
how to remove staging area
What is data transformation manager process?
What is target load order?
Teradata 
