Oracle connect by functionality in DataStage
Moderators: chulett, rschirm, roy
Oracle connect by functionality in DataStage
Hi All,
How can i achieve Oracle connect by functionality in DataStage
regards
madhukar
How can i achieve Oracle connect by functionality in DataStage
regards
madhukar
The PX Documentation contains several chapters on connecting PX and Oracle via different methods on different platforms. What specifically are you asking?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
This, I assume:
http://www.psoug.org/reference/connectby.html
How to replicate this Oracle functionality strictly in a DataStage job.
http://www.psoug.org/reference/connectby.html
How to replicate this Oracle functionality strictly in a DataStage job.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Craig - thanks, I was so much in DataStage mode that I assumed the "connect" meant database connectivity. My bad.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 73
- Joined: Tue May 10, 2005 6:21 pm
- Location: Sydney
-
- Participant
- Posts: 73
- Joined: Tue May 10, 2005 6:21 pm
- Location: Sydney
Well, in our project, the only reason that we want to do it in DataStage could be, I guess, we want to utilize the parallel processing capability of DataStage to handle huge volume of data.
Database like Oracle does have parallel processing ability but it is not as flexible as DS.
Database like Oracle does have parallel processing ability but it is not as flexible as DS.
chulett wrote:Exactly. So, why the 'need' to replicate this in DataStage when your database can do it for you? And if a database isn't involved - get it involved. Load your hierarchical data into a work table (or tables) and source from there.
Edward Yuan