Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different Reporting and ETL tools available in
the market?
- 3 Answers
- 12941 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pattr
No. List of ETL Tools Version ETL Vendors
1. Oracle Warehouse Builder (OWB) 11gR1 Oracle
2. Data Integrator & Services XI 3.0 Business Objects, SAP
3. IBM Information Server (Datastage) 8.1 IBM
4. SAS Data Integration Studio 4.2 SAS Institute
5. PowerCenter 8.5.1 Informatica
6. Elixir Repertoire 7.2.2 Elixir
7. Data Migrator 7.6 Information Builders
8. SQL Server Integration Services 10 Microsoft
9. Talend Open Studio 3.1 Talend
10. DataFlow Manager 6.5 Pitney Bowes Business Insight
reporting tools:
1.SSRS(Microsoft)
2.Business objects
3.Pentaho reporting
4.BIRTS
5.Cognos
6.Microstrategy
7.Actuate
8.Qlikview
9.Proclarity
10.Excel
11.Crystal reports
11. Data Integrator 8.12 Pervasive
12. Transformation Server 5.4 IBM DataMirror
13. Transformation Manager 5.2.2 ETL Solutions Ltd.
14. Data Manager/Decision Stream 8.2 IBM Cognos
15. Clover ETL 2.5.2 Javlin
16. ETL4ALL 4.2 IKAN
17. DB2 Warehouse Edition 9.1 IBM
18. Pentaho Data Integration 3.0 Pentaho
19 Adeptia Integration Server 4.9 Adeptia
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / softinx
Various types of ETL tools like Abinitio,DataStage, Informatica, Cognos Decision Stream, etc https://intellipaat.com/interview-question/pentaho-interview-questions/
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / katelynthomas
ETL Tool is used to get data from many source system like RDBMS, SAP, etc. and convert them based on the user requirement. It is required when data float across many systems. Abinitio,DataStage, Informatica, Cognos Decision Stream, etc
ETL is extraction , transforming , loading process the steps are :
1 – define the source
2 – define the target
3 – create the mapping
4 – create the session
5 – create the work flow
ETL Tool is used for extracting data from the legecy system and load it into specified database with some processing of cleansing data.
| Is This Answer Correct ? | 0 Yes | 0 No |
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
Explain different types of partitioning?
What is partitioning? Explain about round-robin, hash partitioning.
Can u access a repository created in previous version of Informatica?
What is staging area referring to?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
Difference between flat files and relational sources?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
how do u decide whether u need to do aggregations at database level or at Informatica level?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is virtual Data Warehousing?
working of line item dimension......pls,tell overall flow
Teradata 
