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

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?

Question Posted / shankar34

2 Answers
6095 Views
I also Faced
E-Mail Answers

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

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers Puma,

How can we get two output ports in un-connect transformation?

2 Answers Ness Technologies,

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers

What is difference between maplet and reusable transformation?

2 Answers

how to work with mapplet designer in informatica?

7 Answers

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers

What is expression transformation?

0 Answers

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers

when informatica 8 series released ?