Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9435 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
server hot-ws270 is connect to Repository B. What does it mean?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are the types of presistent cache in look up tr.
Explain how to import oracle sequence into informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to create the source and target database connections in server manager?
How many ways are there to create ports?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Can anyone tell me the new features in Informatica 9 Version?
How to use procedural logic inside infromatica?
What is the need of etl tools?
What is an Integration service in Informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
