What are the ETL tools available in DWH?
Answers were Sorted based on User's Feedback
1. Oracle Warehouse Builder (OWB)
2. Data Integrator & Services
3. IBM Information Server (Datastage)
4. SAS Data Integration Studio
5. PowerCenter
6. Elixir Repertoire
7. Data Migrator
8. SQL Server Integration Services
9. Talend Open Studio
10. DataFlow Manager
11. Data Integrator
12. Transformation Server
13. Transformation Manager
14. Data Manager/Decision Stream
15. DT/Studio
16. ETL4ALL
17. DB2 Warehouse Edition
18. Pentaho Data Integration
19 Adeptia Integration Server
20 Clover ETL
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / naveen
POWERCENTER INFORMATICA
ABINITIO
DATASTAGE
HYPERION
OWB
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / jerry jurena
Try CloverETL (www.cloveretl.com) - same functionality&speed
as Informatica or DataStage, much lover cost (some parts
even open source)
| Is This Answer Correct ? | 0 Yes | 1 No |
What is mapping debugger?
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
According to his methodology what all you need before you build a datawarehouse
What are the different caches used in informatica?
what is the dashbords?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
in which situations do u go for scds ?
Define the various join types of joiner transformation?
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
Explain about HLD and LLD ?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?