Interested to Buy Any Domain ? << Click Here >> for more details...
What are the ETL tools available in DWH?
- 6 Answers
- 15476 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 |
How to send duplicates to one target and unique rows to one target?target is empty
Explain the pipeline partition with real time example?
What is a sorter transformation?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
why dimenstion tables are denormalized in nature ?
how you will maintain version?
I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
Can you copy the session to a different folder or repository?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
how to improve performence by using sorted input in aggrigator t/r.
wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15
To provide support for Mainframes source data,which files r used as a COBOL files
Teradata 
