FUNDAMNETAL QUESTION IN DATASTAGE

[skintali]

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

[jseclen]

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.

[skintali]

Hi jseclen,

Thank you so much. It is just my beginning.
I just started to work with DataStage.
Really your answer was a great help for me to give some space requirements.

Regards,
SK

[Teej]

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.