Is scd logic we have lookup right to compare the values with
source and target,instead of lookup can u have any
transformation or any way to do this?

Answers were Sorted based on User's Feedback



Is scd logic we have lookup right to compare the values with source and target,instead of lookup ca..

Answer / naga

We can write Left outerjoin with the target in Source
Qualifier itself or if ur src is file & target is Table
then using Joine(Left outer) can get the new rows loaded
into target

Is This Answer Correct ?    3 Yes 0 No

Is scd logic we have lookup right to compare the values with source and target,instead of lookup ca..

Answer / itsranjan

Hi, Joiner transformation can do the same job what lookup
does in SCD.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,


while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,


how to get the only updated records in the target

2 Answers  


I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,


performance tuning of Informatica

1 Answers  


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

0 Answers  


Why we require dwh in particular projects?

1 Answers   Amdocs,


Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,


What is factless fact schema?

1 Answers  


wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,


Name the different lookup cache(s)?

0 Answers  


What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,


Categories