what are the different Reporting and ETL tools available in
the market?
Answer Posted / aparna
for reporting we have
1)MS-EXCEL
2)ACUTATE
3)OBIA
4)HYPERION(BRIO)
for ETL we have
1)TERADATA
2)ODI
3)DATA STAGE
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
what is session partitioning?
where we cannot use sorter Transformation. if we use then we will not get correct data?
Explain the use lookup tables and Aggregate tables?
if i have a query as flat file how can we load data to target table
What is staging area referring to?
what is Forward,Reverse and Re_engineering?
What are cubes and olap cubes?
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 the etl testing operations includes?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Explain about round-robi?
what is the difference steps for data modeling?
Can u access a repository created in previous version of Informatica?
Explain do we need an etl tool? When do we go for the tools in the market?
how do u set partition points in the mapping?