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
- 9752 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
Explain the types of transformations?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
write a query to retrieve the latest records from the table sorted by version(scd)
How to load the data from people soft hrm to people soft erm using informatica?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the settings that you use to configure the joiner transformation?
What is event and what are the tasks related to it?
How to generate sequence numbers?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are active transformations.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
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
Can we create a node as a gateway node and the same node can be assigned to a grid?
How might one distinguish in the case of mapping is right or not without associating session?
pmscmd startworkflow -sv
