How to delete duplicate record in Informatica?

Answer Posted / mayuresh

Hi,

how to delete duplicate values from table if source and
target are same

my Question is which logic we need to apply before using
DD_DELETE option in update strategy ?

Do we require to use aggregator to group the values and if
there count > 1 then DD_DELETE

PLZ reply

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly explain the aggregator transformation?

589


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

784


What is informatica powercenter repository?

709


On which transformations you created partitions in your project?

759


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

719






How to use pmcmd utility command?

578


how many types of dimensions are available in informatica?

559


Difference between Data and Index Caches?

649


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

603


What are the modules in Power Center

1228


permutations of mapplet

2038


How do you take back up of repository?

717


Where do we use mapping variables in informatica?

612


Define update strategy?

633


How union transformation is used?

591