SCD2 will work on only dimension tables as well as fact Table?
No Answer is Posted For this Question
Be the First to Post Answer
What are the steps involved in etl process?
can be used COM component in Informatica ?
what are the data modeling tools you have used?(polaris)
1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com
flat filevalidation in informatica
how do u set the size of block buffer?
Explain do we need an etl tool?
What are dimensions?
What is etl process? How many steps etl contains?
how do use session mapping parameters ?(in which transformation)
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?
What are the three tiers in etl?