Hi Raju,
There are so many reasons to say why Datastage instead of Informatica.
Datastage has a Universe Database
You can create your own Functions and scripts
Has hash file which is very useful for lookup
Faster than Infomatica and jobs can be tunned for performance
Version Control
etc.
these are few out of many.
Cheers
Rasi
Why should one go for Datastage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It really depends on how you prefer to design your ETL. DataStage uses more of a top-down approach, where you visualise and model the data flow, then fill in the details of what data and where. I like its automatic management of metadata, too.
Last time I looked at Informatica, it was more of a bottom-up strategy, and required one to do a lot more scripting than DataStage. But this is a couple of years back, and they may have improved it since.
I believe that DataStage can connect to a much greater range of data sources than Informatica. The DataStage plug-in architecture means that it is easier to maintain and has lower TCO into the future (over the typical life of a DW), and with parallel extender can blow any competitive ETL product out of the water in terms of throughput performance.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Last time I looked at Informatica, it was more of a bottom-up strategy, and required one to do a lot more scripting than DataStage. But this is a couple of years back, and they may have improved it since.
I believe that DataStage can connect to a much greater range of data sources than Informatica. The DataStage plug-in architecture means that it is easier to maintain and has lower TCO into the future (over the typical life of a DW), and with parallel extender can blow any competitive ETL product out of the water in terms of throughput performance.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518