I have a situation here to load the Table into informatica.I have 5 temporary tables as sources. They look like:Table1: (K - Key, N-Null, X,Y,Z - values)K1 X N N N NK2 X N N N N--------------------------Table2: K1 N X N N NK2 N X N N N--------------------------the other 3 tables are in the same way. But there can be a situation like any of the table can contain duplicates like:K1 X N N N NK1 Y N N N N--------------------------This kind of records should be errored out.Because of this, we can't use aggregator/group by as we are not sure which one should be removed.How can we obtain this functionality in Informatica.Any help would be appreciated. Thanks

skymoon
Profile Answers by skymoon Questions by skymoon
May 27th, 2006
1
1986

Showing Answers 1 - 1 of 1 Answers

afzal pathan

May 27th, 2006

Do the following
Map1..Source instance s1---Source qualifier?aggregator transformation---t1(target)
                                                                                      |
                                                                                      |
                                                                 In aggregator transformation
                                                 Count_ port(output port)= key port --group by key port
Now take your original port with eliminated duplicate key port?s record in map2

Map2..Source instance( t1)---source qualifier---take your original port with eliminated duplicate key records--- and now do your requirement design .
               :for more details mail me at afzal_pathan9@rediffmail.com