What are the three tiers in etl?
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
what is the difference steps for data modeling?
what is Forward,Reverse and Re_engineering?
What is partitioning? Explain different types of partitioning?
how do u set partition points in the mapping?
what is pmrep command?
what are the session parameters? How do u set them?
What is a materialized view log?
What is the difference between project backlog and product backlog?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Explain about the data integration suite features?
what is the use of server?
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?