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 |
How to convert multiple rows to single row (multiple columns) in informatica
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
How to use procedural logic inside infromatica?
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
when we dont use aggregator in mapping ?
What is incremental aggregation?
what is the significance of newlookup port in dynamic look up
What is primary and backup node?
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
Tell me about informatica architecture.
How do you load unique records into one target table and duplicate records into a different target table?
If we have lookup table in workflow how do you trouble shhot to increase performance?