DSXchange

Hi all;


i need to caliculate change_in_total_net_assets based on same fund name

and previous years filing date
eaxmple;

Source
field 1 field2 field3
(fundname) (totanetassets) (date)

wade fund inc 667 12/31/2002

the internet fund 14500 12/31/2004


wade fund inc 631 6/30/2003


target;


field1 field2 field3

fundname total_net_assets change_in_totl_net_assets

wade fund inc 667

the internet fund 14500

wade fund inc 631 36


method for populating filed (chanage_in_total_net_assets)

if the fund already exists with the previous uears filing , find differnces in TNA for the two dates.


can anyone please explain to me how to populate that filed.?

i know we can do it using stage variables, but i don't know how to write

in stage variable

Hi Harithay,

If you know stage variables can do it and dont know how to write them then do a search on stage variables in the Server forum. There are a lot of examples that have been discussed.

Rich

Hello rich,

i don't know how to use stage variables. can u please let me know how to use stage variables for my problem.

Harithay --

You have the following options:

1. Read. Parallel Job Developer's Guide (parjdev.pdf) provide an excellent resource. Check out Chapter 15 - Transformer.

2. Search. This forum have a long history of information that is very useful for you. Do a search for "stage variables".

3. Train. Ascential/IBM provide excellent training classes to help get you up to speed with DataStage EE. Contact Ascential/IBM for more information.

4. Hire. Hire a DataStage expert to do this job, and/or teach you how to do it.

Your questions are very basic, and have been answered in many different ways. I suggest doing #1 and #2. If both are too much for you, #3 and/or #4 would be your best course of action.

Thanks T42;

I got it how to use stage variable.

anyway thanks for ur suggestions.