Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different Reporting and ETL tools available in
the market?
- 3 Answers
- 13052 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 difference between cardinality and Nullability?
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?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What are the ETL Testing Operations?
what are the concerns of OLTP and DSS systems?
what are the data modeling tools you have used?(polaris)
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
How etl testing is different from database testing?
what is the main role of FI on business
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
What are the etl testing operations includes?
What are materialized views & where do we use them?
Teradata 
