How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,


in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,


what is fact and what types of fact tables is there

4 Answers   Cap Gemini,


What is source qualifier?

6 Answers   SDS,


Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,






how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,


Diffrence between static and dynamic cache

2 Answers   HCL,


Hi 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....

1 Answers  


What are the parts of Informatica Server?

1 Answers   Cognizant,


We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  


what is parallel querying and what r hints.

1 Answers  


Differences between connected and unconnected lookup?

0 Answers  


Categories