Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
- 5 Answers
- 10458 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
If both exist in same database then you can use NOT EXIST
function to find out the missing rows.
If both exist in diff databases then you can join them using
joiner and compare the rows in expression and Raise a Flag
for not matching rows.You can then use filter and pass only
the non matching rows into the target.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you mean by channel change?
can u any challenge your project?
What is the function of union transformation?
What is the difference between stop and abort in informatica
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is the status code in stored procedure transformation?
How to join three sources using joiner? Explain though mapping flow.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the advantage of informatica?
permutations of mapplet
Differentiate between joiner and lookup transformation?
Mention few power centre client applications with their basic purpose?
What are mapplets?
where to store informatica rejected data? How to extract the informatica rejected data?
Why filter transformation is an active one?
