Hello,
I am new to datastage.
To start with, I want to know if I source data from an oracle table and load some summarized data into a target table, do I need a space on the datastage server for doing the summarization? Basically, it is a select with sum of some columns and group by some key columns and then the result is to be sent to the target table.
Thanks in advance.
sk
FUNDAMNETAL QUESTION IN DATASTAGE
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Re: FUNDAMNETAL QUESTION IN DATASTAGE
Hi SK
If you want to load sumarize records from an oracle table you have two choices:
1) Using a sql sentences that sumarize and return the records agregatted and load or ..
2) Using the DataStage agregator to sumarize for the fiels that you needed, in this case you will need temporary space to calculate this
The first option don't need space in the DataStage server, only in the Oracle server,...
I hope this help.
If you want to load sumarize records from an oracle table you have two choices:
1) Using a sql sentences that sumarize and return the records agregatted and load or ..
2) Using the DataStage agregator to sumarize for the fiels that you needed, in this case you will need temporary space to calculate this
The first option don't need space in the DataStage server, only in the Oracle server,...
![Laughing :lol:](./images/smilies/icon_lol.gif)
I hope this help.
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
The only time you _REALLY_ need to start thinking about space usage is when you use Parallel Extender. Other than that, just ensure that your Project folders have sufficient space, your hash folder have sufficient space, and your temp directory have sufficient space.
How much space? It depends on what you want to do.
-T.J.
How much space? It depends on what you want to do.
-T.J.
Developer of DataStage Parallel Engine (Orchestrate).