Dynamic Relational Stage

ranga1970 · Post by **ranga1970** » Wed May 04, 2005 11:49 am

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

rasi · Post by **rasi** » Wed May 04, 2005 8:26 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed May 04, 2005 9:00 pm

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