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
- 9623 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srini
In this case check Target table should have Record update
timestamp along with Insert time stamp
Other wise Check the max time stamp it will help.
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
EXL informatica Questions
What is a shortcut and copy in Informatica and how two are different with each other?
How can we create index after completion of load process?
What are some examples of informatica etl programs?
what is informatica metadata?
What is the reusable transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
Can we create a Integration service without a Repository service and vice versa?
Explain what are the different types of transformation available in informatica.
what is the -ve test case in your project.
What are the performance considerations when working with aggregator transformation?
What is workflow? What are the components of workflow manager?
What is the Rank index port in Rank transformation?
Explain lookup transformation source types in informatica
How to update or delete the rows in a target, which do not have key fields?
