what are the different Reporting and ETL tools available in
the market?
Answers were Sorted based on User's Feedback
Answer / manoj rana
hi,
reporting tools available are:
1.BO 2.COGNOS 3.OBIEE
Etl tools:
1.informatica
2.datastage
3.ODI(oracle data integrator)
Is This Answer Correct ? | 17 Yes | 2 No |
Answer / kumarbng
HI,
Reporting :
Business Objects, Cognos, Crystal reports etc
ETL:
Informatica, Buisness Objecst Data Services
Is This Answer Correct ? | 14 Yes | 4 No |
Answer / 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 |
how do use session mapping parameters ?(in which transformation)
What are the etl testing operations includes?
What are the steps involved in etl process?
what is the difference between shortcut of an object and copy of an object? compare them?
what are the data modeling tools you have used?(polaris)
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?
what do u do when DB time takes more?in sap bi
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?
what is pmrep command?
What do you understand by active and passive transformations?
what are the different forms of normalization?
SCD2 will work on only dimension tables as well as fact Table?