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?


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

Post New Answer

More ETL Interview Questions

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

0 Answers  


what are the data modeling tools you have used?(polaris)

0 Answers  


What are cubes and olap cubes?

0 Answers  


what are the different Reporting and ETL tools available in the market?

3 Answers  


what do u do when DB time takes more?in sap bi

0 Answers  






Difference between flat files and relational sources?

2 Answers  


What is tracing level? How many types of transformations supported by sorted input?

0 Answers  


Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

0 Answers  


what is data modeling?

0 Answers  


1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

0 Answers  


what are the session parameters? How do u set them?

0 Answers  


What are the names of the layers in etl?

0 Answers  


Categories