DSXchange

Folks;
We have enterprise stage for oracle, informix and so on, but using Dynamic Relational Stage also we can connect to these database can any one help me to understand, when do we use Dynamic Relational Stage and when do we use enterprise stage for particular type.
how to differntiate them,

thanks
ranga

Always use the Native Stages in the jobs. Dynamic Relational Stage can be used in the project where you keep changing the databases. Helpful in the proof of concept stage, or when you are not sure about which database its going to be used in future for the project.

Thanks

And, of course, DRS can connect by some means that aren't otherwise available in PX (ODBC springs to mind, and SQL Server).