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
- 9595 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 expression transformation?
What is union transformation?
What are pre and post-session shell commands?
What are the issues you have faced in your project? How did you overcome those issues?
wf dont have integration severances how you can run?
What are mapplets?
What is an expression transformation in informatica?
can we override a native sql query within informatica? Where do we do it?
What are the mapping parameters and mapping variables?
What are the various types of transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain in detail about scd type 1 through mapping.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are some examples of informatica etl programs?
can u any challenge your project?
