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
- 8890 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / hollister
The key coluns that are common in both tables are to be
considered and compare each field in both tables. If there
is any change in any of the column in table B then it is
the updated column.
| Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
server hot-ws270 is connect to Repository B. What does it mean?
How might you approve all mappings in the archive all the while?
How can we store previous session logs?
What is a passive transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How might one distinguish in the case of mapping is right or not without associating session?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Where is metadata stored?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
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 what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do you take back up of repository?
What is substr in informatica?
can you please explain me pre session and post session options?
What is session task and command task?
