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

What is difference between a connected look up and unconnected look up?

6 Answers  


Does Facttable Normalized or Denormalized?

2 Answers   IBM,


what happens when a batch fails?

3 Answers  


if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,


The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,






hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  


Where do you create/define mapping parameter and mapping variable?

1 Answers  


in which situations do u go for snowflake schema ?

2 Answers   TCS,


As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,


I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,


Categories