how to send unique records to one target and duplicate
records to another target by using dynamic lookup cache?????
please explain me briefly///(when we use this we look up on
which target unique target ya duplicate target)

Answers were Sorted based on User's Feedback



how to send unique records to one target and duplicate records to another target by using dynamic l..

Answer / sarvesh

whenever we create dynamic lookup a default col gets added i.e. newlokuprow it has a defaul value 1 for insert that is newrow and 0 for delete or duplicate or same row which already exists. so just use router tr and separate the 0 value row will eliminate the duplicates.

Is This Answer Correct ?    9 Yes 6 No

how to send unique records to one target and duplicate records to another target by using dynamic l..

Answer / harish konda

We know that Dynamic Look Up Cache returns 1 for insert and
2 for update. So connect the source to the lookup which is
Dynamic and in next in router create 2 conditions. Records
which new it will return 1 and records which are there it
returns 2.

Is This Answer Correct ?    4 Yes 3 No

how to send unique records to one target and duplicate records to another target by using dynamic l..

Answer / dave

May be i understood question wrong , but :
For unique records you can use in Source Qualifier SQL with
having count condition = 1 to cut the unique records to one
target
And for second target same query but with >1 condition
---

Is This Answer Correct ?    2 Yes 9 No

Post New Answer

More Informatica Interview Questions

what is row level and column level indicator?

1 Answers   TCS,


what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,


What is a design?

1 Answers  


What are the types of maping in Getting Started Wizard?

1 Answers  


I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,






What is the use of source qualifier?

0 Answers  


Why we use lookup transformations?

1 Answers  


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  


How many repositories can we create in Informatica??

9 Answers   IBM, Patni,


Please let me know how to make Data masking in informatica..

0 Answers  


scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  


By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  


Categories