How we can get unique records into one target table and
duplicate records into another target table??

Answer Posted / bala

in router count(*)=1 for good record

count(*)>1 for duplicate record

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can anyone tell me the new features in Informatica 9 Version?

1530


Differences between version 7.x and 8.x.

1417


In informatica workflow manager, how many repositories can be created?

778


What is workflow monitor?

593


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

694






What is a predefined event?

656


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1578


Could you explain what is enterprise data warehouse?

553


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1848


How many transformations can be used in mapplets.

1456


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1932


how to create user defined function (udf) in informatica

783


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1771


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1586


What does reusable transformation mean?

672