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
- 8565 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Enlist some properties of sessions.
What is the need of etl tools?
What is the advantage of informatica?
How might one distinguish in the case of mapping is right or not without associating session?
Clarify the utilization of aggregator cache record?
In development project what is the process to follow for an etl developer from day1
how to load dimension table and fact table. plz tell me the steps.
What is the use of code page?
update strategy transformation in informatica
what is song in infrmatica...?
What are data-driven sessions?
What is Index Caches size?
Explain what transformation and how many are there in informatica?
What is union transformation?
Define mapping and session?
