what are the different Reporting and ETL tools available in
the market?
- 3 Answers
- 12189 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 |
what is the use of structures?how many nodes can u create in a structure?
what is the difference between normal & bulk loading? and which one is recommended ? why?
what is the advantage of persistent cache? when it should be used?
Difference between flat files and relational sources?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What are the etl testing operations includes?
What are your responsibilities as an etl tester?
What are dimensions?
what is pmrep command?
Explain do we need an etl tool?
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
Compare ETL & Manual development?
Teradata 
