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

Answers were Sorted based on User's Feedback



how can send duplicate records to one tableand non duplicate records to one table with simple clea..

Answer / sivananda reddy

In informatica use this mapping

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

Is This Answer Correct ?    3 Yes 0 No

how can send duplicate records to one tableand non duplicate records to one table with simple clea..

Answer / roshan

hey u have to write a stored procedure to compare each record and then use a router T/R, if the record is non duplicated then it sends to one target and duplicated records to another target.. hope it works..
let me know if better option is available..
infernonag@gmail.com

Is This Answer Correct ?    1 Yes 1 No

how can send duplicate records to one tableand non duplicate records to one table with simple clea..

Answer / rajan raorane

You can use Router where One update strategy is directy
connected to Target table while other update strategy must
be followed by sorter with DISTINCT check which shud be
further connected to target table

This will differntiate Duplicate and non-duplicate records
in target table

Is This Answer Correct ?    0 Yes 0 No

how can send duplicate records to one tableand non duplicate records to one table with simple clea..

Answer / gopi

For this i have seen one excellent video in YOUTUBE. Please
check this site.

Is This Answer Correct ?    0 Yes 2 No

how can send duplicate records to one tableand non duplicate records to one table with simple clea..

Answer / radhakrishnansk

Considering the source as flat file.
src-->Src qual ---> sorted transfomation -->trgt
|
|---> trgt
In sorted transformation, we can choose distict in
properties. So the duplicate is avoided.

correct me if I am wrong

Is This Answer Correct ?    1 Yes 11 No

Post New Answer

More Informatica Interview Questions

Is it possible to use a client with different version than that of its Informatica server?

0 Answers  


Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,


How will you update the row without using update statergy?

10 Answers   CTS,


How to go to the older version for a mapping?

0 Answers  


What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,






Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  


how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,


How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  


What is different between the data warehouse and data mart?

0 Answers  


If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,


What is the scenario which compels informatica server to reject files?

0 Answers  


i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  


Categories