Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?
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 happens if the info.server doesn't find the session parameter in the parameter file?
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
Define Dynamic push down optmization?
what is data modeling?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
Do we need an ETL tool? When do we go for the tools in the market?
What is virtual Data Warehousing?
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
what are variable ports and list two situations when they can be used?
Difference between flat files and relational sources?