Can some one explain me what is purpose and function fo DRS stage in DS7.5 , how it different from ODBC stage.
thank you,
DRS stage
Moderators: chulett, rschirm, roy
The Dynamic Relational Stage allows you to connect to any supported database with a single stage, which means you could (theoretically) swap out your underlying database and only have to change a single parameter to continue to use the same jobs. Reality is a harsh mistress, however, and it doesn't always work out that easily.
If there is a supported 'native' interface for the RDBMS then the DRS stage will use that (like OCI for Oracle) otherwise it will fall back on ODBC.
This is all documented with the product.
If there is a supported 'native' interface for the RDBMS then the DRS stage will use that (like OCI for Oracle) otherwise it will fall back on ODBC.
This is all documented with the product.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I go for the native database stage first as it tends to have the most functionality and the fastest performance. The Oracle OCI stage in particular has a query builder and a synchronise columns option that are missing from the DRS and ODBC stages.
If I need the switch database ability I go for the DRS stage.
The ODBC stage comes with a stored procedure query type and a multiple row lookup option that sometimes make it preferable. It also has less installation issues. Native connectivity requires the installation of the RDBMS client on the DataStage server whereas the ODBC drivers are installed with DataStage.
No matter what type of database stage I use I always try to use generated SQL as this makes maintenance and metadata reporting a lot easier.
If I need the switch database ability I go for the DRS stage.
The ODBC stage comes with a stored procedure query type and a multiple row lookup option that sometimes make it preferable. It also has less installation issues. Native connectivity requires the installation of the RDBMS client on the DataStage server whereas the ODBC drivers are installed with DataStage.
No matter what type of database stage I use I always try to use generated SQL as this makes maintenance and metadata reporting a lot easier.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn