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
- 9727 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
tell me 5 session failure in real time how can you solve that in your project?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is a pre-defined event and user-defined event?
Difference between Target-based loading and constraint-based loading?
How to generate sequence numbers?
pmscmd startworkflow -sv
What is a router transformation?
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?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are batches?
To import the flat file definition into the designer where should the flat file be placed?
Explain why we use partitioning the session in informatica?
What is the fact table?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How we can use union transformation?
