Define slowly changing dimensions (SCD)?


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

Post New Answer

More ETL Interview Questions

what are Lookup caches options? Including persistent caches.

0 Answers  


when will use SQL override in a lookup transformation?

0 Answers  


Give the benefits of data integration suite?

0 Answers  


how do use session mapping parameters ?(in which transformation)

0 Answers  


please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

0 Answers  






How to increase performance without changing anything in mapping.( In prod)

0 Answers   IBM, Saama Tech, Wipro,


What are the different Lookup methods used in Informatica?

0 Answers  


what happens if the info.server doesn't find the session parameter in the parameter file?

2 Answers  


when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

0 Answers  


A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

0 Answers  


Is hadoop a etl tool?

0 Answers  


how would u estimate the size of Lookup transform data and index cache?

1 Answers  


Categories