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
- 9436 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
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How does a sorter cache works?
What is the use of an aggregator cache file?
How can we use mapping variables in informatica? Where do we use them?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Explain the scenario which compels informatica server to reject files?
What is sequence generator transformation in informatica?
What is workflow? What are the components of workflow manager?
What are the new features of Power Center 5.0?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Describe the impact of several join conditions and join order in a joiner transformation?
What is intricate mapping?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
