Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - How to extract original records at one target & Duplicate records at one target?




591
views
asked marvit September 20, 2014 08:04 AM  

How to extract original records at one target & Duplicate records at one target?


           

1 Answers



 
answered By vishnoiprem   0  
Yes you can do it by using Expression transformation as well. infact, by using 2 SQ (source qualifier) and using
sql queries (as I explained earlier), you can perform the required task on relational tables only (but not on flat files etc).
In the case of flat files as source, you will need to use Expression transformation. But you also need to use sorter
before expression (otherwise record flag will change for every incoming record & duplicates won't be traced).
The sequence of transformations will be as follows -

Source -> SQ -> Sorter ->Expression ->Router(or 2 filters) ->Targets

Second Method:

First Pipeline:

SQ--Sort---Tgt1

Second Pipeline:

SQ--Lkp on Tgt1--If The value is matched from both the table
send it to Tgt2.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert