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

What are the different clients of powercenter?

605


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1539


What is the status code in stored procedure transformation?

689


What is meant by active and passive transformation?

590


What is parallel processing in informatica?

1033






What are some examples of informatica etl programs?

540


Explain the types of transformations?

602


What is lookup transformation?

606


Enlist the advantages of informatica.

636


What are the issues you have faced in your project? How did you overcome those issues?

1918


What are the main issues while working with flat files as source and as targets ?

660


Briefly define a session task?

595


How can one identify whether mapping is correct or not without connecting session?

886


What is a code page?

721


How do you load only null records into target?

742