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
- 9747 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ankur saini er.ankur861@gmail.
hi...i think this cannt be done without an audit columns ..
a date or batch id etc..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is song in infrmatica...?
Explain the informatica workflow?
What are the measure objects?
What is meant by incremental aggregation?
What are mapplets?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are pre and post-session shell commands?
Implementation methodology
can anyone explain me about retail domain project in informatica?
difference between repository database and repository service?
Why union transformation is an active transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain the types of transformations?
