how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?

Answer Posted / sivananda reddy

In informatica use this mapping

source->sqr->aggr->router->exp->target1
|
|->exp->target2

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Session and Batches?

773


Explain the pipeline partition with real time example?

752


Mention some types of transformation?

703


What do you mean by filter transformation?

644


What is session task and command task?

741






I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1201


Explain what are the different types of transformation available in informatica.

664


Explain constraint based loading in informatica

748


According to his methodology what all you need before you build a datawarehouse

1291


What is a node in Informatica?

723


What is workflow? What are the components of workflow manager?

812


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

733


How do you load only null records into target?

839


How can we create index after completion of load process?

687


How to create a non-reusable instance of reusable transformations?

784