how do u estimate the number of partitions that a mapping
really requires? Is it dependent on the machine configuration?
No Answer is Posted For this Question
Be the First to Post Answer
What is etl process? How many steps etl contains?
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?
Explain etl mapping sheets?
What is granularity? Please explain with example
What is a staging area? What is the purpose of a staging area?
what are Lookup caches options? Including persistent caches.
what is HISTOGRAM? how to generate statistics?
explain the methodology of Data Warehousing?(Polaries)
what is data modeling?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what is data modeling?
What is etl process?