If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING..
CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE
RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?



If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPU..

Answer / babu

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

if any thing is wrong please let me know.

Cheers,
babu

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Informatica Interview Questions

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

0 Answers   CTS, FEEE, TCS,


Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,


Explain how many types of dimensions are available in informatica?

0 Answers  


what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  






can we use self join in informaitca?

3 Answers   IBM,


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,


what is target load plan

2 Answers   Cap Gemini,


Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,


My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,


Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,


Categories