Explain the key challenges that you face while performing etl testing.
No Answer is Posted For this Question
Be the First to Post Answer
how do u decide whether u need to do aggregations at database level or at Informatica level?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
What is etl process. How many steps etl contains explain with example?
how would u estimate the size of Aggregator transform data and index cache?
what is dynamic insert?
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 dimensions?
explain the methodology of Data Warehousing?(Polaries)
how would u estimate the size of Lookup transform data and index cache?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
State the differences between shortcut and reusable transformation
when will use SQL override in a lookup transformation?