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

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