Hi ETL gurus can any one tell me with a flow how to
implement SCD Type 1 and SCD Type 2 in a single mapping.For
some fields SCD type has to be implemented and for some
fields scd type has to be implementd..Thank in
advance..please let me know in case of any concerns...



Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single..

Answer / hemanth

yes, u can see the out put in single run,
in mappings tab one option is there, that is TARGET LOAD
ORDER.


yes we can do scd type1 and scd type2 in a single mapping
itself when the source is same for both. But with same
source we will never face that situation if so the changes
in source will reflect both scd1 and scd2.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

Explain the pipeline partition with real time example?

0 Answers   Informatica,


Why the workflow is failed after running two hours in informatica?

1 Answers   GE,


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  


how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,


What is different between the data warehouse and data mart?

0 Answers  






any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  


What do you mean by worklet?

0 Answers  


When the informatica server marks that a batch is failed?

2 Answers  


In Which scenario did u used Incremental loading?

2 Answers  


Categories