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 |
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
How do you use reject loader.
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
how i will stop my workflow after 10 errors
Performance tuning( what you did in performance tuning)
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
How do you implement configuration management in Informatica?
how do u move the code from development to production?
What is enterprise data warehousing?
What is session task and command task?