Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different Reporting and ETL tools available in
the market?
- 3 Answers
- 13053 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 are the key benefits of ETL Testing?
where is the cache (lookup, index) created and how can you see it.
SCD2 will work on only dimension tables as well as fact Table?
Can u access a repository created in previous version of Informatica?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
What is data cleaning?
how do u set the size of block buffer?
what is the indicator file and where it is used?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Do we need an ETL tool? When do we go for the tools in the market?
How to Check the source record count from traget table.
In Which Transformation We Can Use Having Clause In Informatica?
Teradata 
