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
stage variable usage
Moderators: chulett, rschirm, roy
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.
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.