Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different Reporting and ETL tools available in
the market?
- 3 Answers
- 12999 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 types of repositories we can create in informatica? in real time in which type of repository we will work on?
Explain about enterprise scalability and roi of data integration suite?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
list and discuss two approaches for updation of target table in Informatica and how they are different.
where are the log files generally stored.Can you change the path of the file.what can the path be?
what are the reporting tools and difference between them?
How to delete data which is not in source table?
0 Answers IBM, Saama Tech, Wipro,
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
how does the server recongnise the source and target databases.Elaborate on this
what are the types in error loging?
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
Identifying the bottlenecks in various components of Informatica and resolving them.
Teradata 
