Page 1 of 1
API Stage
Posted: Thu Feb 05, 2009 5:16 pm
by kumar66
Hi All,
Just curious , what is the diffrence between API stages and Enterprise Stages.
Please Advice.
Thanks & Regards,
Kumar66
Posted: Thu Feb 05, 2009 7:36 pm
by ray.wurlod
Posted: Thu Feb 05, 2009 11:04 pm
by fareeda_b
Hi Kumar,
The DB2/UDB Enterprise (native parallel) stage should be used for reading from, performing lookups against, and writing to a DB2 Enterprise Server Edition database with Database Partitioning Feature
- As a native, parallel component, the DB2/UDB Enterprise stage is designed for maximum performance and scalability against very large partitioned DB2 UNIX databases.
- The DB2/API (plug-in) stage should only be used to read from and write to DB2 databases on other platforms (such as mainframe editions through DB2-Connect). DB2 API stage should be used to access data from DB2 database, installed in a different operating system than the ETL server. Sparse Lookup is not supported through the DB2/API stage.
Hope this will help you
thanks
fareeda
Posted: Fri Feb 06, 2009 2:05 am
by kumar66
Hi Fareeda_b,
Thanks for your reply.
Regardsm
Kumar66