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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the Methods For Creating Reusable Transformations?

647


What is meant by lookup transformation?

608


How can you differentiate between powercenter and power map?

621


Briefly explain the aggregator transformation?

589


How do you load unique records into one target table and duplicate records into a different target table?

705






What are the prerequisite tasks to achieve the session partition?

709


What you know about transaction control transformation?

554


What is data movement mode in Informatica and difference between them?

616


Separate from a database, an information bazaar, and an information stockroom?

605


How to do the error handling of if ur source is flatfiles?

1506


What is standalone command task?

705


What does reusable transformation mean?

670


how to load rows into fact table in data warehouse

637


What is complex mapping?

635


How you know when to use a static cache and dynamic cache in lookup transformation?

1333