Interested to Buy Any Domain ? << Click Here >> for more details...
What are the ETL tools available in DWH?
- 6 Answers
- 15315 Views
- Mphasis, I also Faced
- E-Mail Answers
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 |
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
Insert else update option in which situation we will use
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
How to extract sap data using informatica? What is abap? What are idocs?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
What is Data Caches size?
Is it possible to have "5 source & 5 Target" in single mapping?
what is the use of Data Mart?
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
Teradata 
