sample mappings for scd1,scd2 and scd3

Answer Posted / nikhil tiwari

check this site for SCD-2 step by step implementation:

http://deepinopensource.blogspot.in/2013/03/scd-2-implementations-in-informatica.html

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you load only null records into target? Explain through mapping flow.

1490


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1328


explan ur project architecture?

1587


Explain the types of lookup transformation?

560


How many ways are there to create ports?

716






explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1699


What is the different lookup cache(s)?

607


Difference between Target-based loading and constraint-based loading?

548


Explain why we use partitioning the session in informatica?

607


What are the new features of informatica 9.x at the developer level?

600


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

616


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

697


What is a predefined event?

654


How to generate sequence numbers using expression transformation?

633


How to generate or load values in to the target table based on a column value using informatica etl tool.

604