Hi All,
Why do we need DRS stage? Can't we use the existing native stages for their respective databases? Is there any specific on using DRS? Does it effec any kind of extraction or loading process?
If my DB is DB2 on EPM, do i have to use DRS only or can i go with DB2UDB stage?
Are the OraOci, OraBulk, DB2UDB, BCPBulk, ODBC comes with DataStage or do we have to buy the plugins apart from DataStage?
Pleaes clarify me.
Why do we need DRS though we have OraOci, DB2UDB, BCP, ODBC
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 37
- Joined: Sun Aug 01, 2004 1:18 am
Why do we need DRS though we have OraOci, DB2UDB, BCP, ODBC
Thanks,
Cnu
We work together to workout...
Cnu
We work together to workout...
You never "have" to use the DRS stage. From what I understand, it was created as part of the PeopleSoft deal. The goal was to allow your jobs to be "database independant" - a simple switch of a parameter and they go from talking to Oracle to any other supported database, for example.
Of course, it isn't always that simple in Real Life, as there are syntax differences and metadata differences between the same datatype across databases, things like Timestamps for example. I really don't think it worked out quite as seemlessly as "they" would have liked. I haven't had a burning need to use or even play with them much yet, to be perfectly honest.
I'm not aware of any advantages or disadvantages of the DRS over the corresponding native stage. Perhaps someone who's actually using them could offer an opinion...
And yes, the plug-ins you listed all come with DataStage.
Of course, it isn't always that simple in Real Life, as there are syntax differences and metadata differences between the same datatype across databases, things like Timestamps for example. I really don't think it worked out quite as seemlessly as "they" would have liked. I haven't had a burning need to use or even play with them much yet, to be perfectly honest.
I'm not aware of any advantages or disadvantages of the DRS over the corresponding native stage. Perhaps someone who's actually using them could offer an opinion...
And yes, the plug-ins you listed all come with DataStage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi,
We came across a situation where using DRS is advantageous over native stage for DB2.
We are implementing NLS in one of our projects. Our source data come from AS/400 systems. In the source tables we have multi-lingual data across columns. DRS stage supports NLS at column level whereas DB2 stage supports this only at table level.
We came across a situation where using DRS is advantageous over native stage for DB2.
We are implementing NLS in one of our projects. Our source data come from AS/400 systems. In the source tables we have multi-lingual data across columns. DRS stage supports NLS at column level whereas DB2 stage supports this only at table level.
Nitin Jain | India
If everything seems to be going well, you have obviously overlooked something.
If everything seems to be going well, you have obviously overlooked something.
as pointed out by other DRS is DB independent and offers the flexibility of using with multiple db's.
Yes the OCI have a better way of handling the data structures if your source and target database is oracle.
Yes most of the common db have the plugins delivered with the Datastage tool.
Yes the OCI have a better way of handling the data structures if your source and target database is oracle.
Yes most of the common db have the plugins delivered with the Datastage tool.
Baig
Nothing is Impossible in this world. TRY ..try till you Succeed.