Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
1 4679how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
2886how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
1 3722
what make u disappointmnets in u r career
When do we analyze the tables?
How many types of transformations supported by sorted input?
Explain me ETL project architecture in Detail?
Define slowly changing dimensions (SCD)?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
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 is data modeling and data mining?
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?
explain the methodology of Data Warehousing?(Polaries)
How many steps etl contains explain with example?
Compare ETL & Manual development?
When do we go for the tools in the market?
What is partitioning? Explain different types of partitioning?
when will use SQL override in a lookup transformation?