Informix Database Stages
Moderators: chulett, rschirm, roy
Informix Database Stages
We are using Informix as source database. Datastage 7.5 Enterprise supports Informix Enterprise,Informix Client,INformix Load. I need more understandinmg on these stages like which one is fast in performance wise. and is the performance same in server and in parallel?
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Define "performance".
Rows/second is meaningless, as I've noted - and proven - on a number of occasions.
Enterprise stages have innate parallel capability, and so would be the stage type of preference to communicate with XPS particularly.
API stages are essentially the same stages you used in server jobs.
Bulk load stages invoke the bulk loader technology which, provided all the rules are satisfied, are typically the fastest mechanism for getting data into a table.
Rows/second is meaningless, as I've noted - and proven - on a number of occasions.
Enterprise stages have innate parallel capability, and so would be the stage type of preference to communicate with XPS particularly.
API stages are essentially the same stages you used in server jobs.
Bulk load stages invoke the bulk loader technology which, provided all the rules are satisfied, are typically the fastest mechanism for getting data into a table.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.