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
- 8870 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
How to extract the informatica rejected data?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Differentiate between reusable transformation and mapplet.
What are the different versions of informatica?
Explain about cumulative Sum or moving sum?
What is flashback table ? Advance thanks
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to handle decimal places while importing a flatfile into informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are the modules in Power Center
What is the difference between Active and Passive transformation?
What are the different lookup cache(s)?
What is an expression transformation?
