DSXchange

Hi, Could you please elabortate a bit further 1.Sort the data on Acc_K,Serv_K,Period_K and Amt field in the Ascending order. 2. In Transformer stage, group the data based on (Acc_K Serv_K Period_K Called_N) and select the first 100 rows for each set. How do you do this in transformer. Thanks Munish

Good Thought.

Is there any property in Aggregator to take care of this.

Thanks
Munish

Data before passing to AGGREGATOR Acc_K Serv_K Period_K Called_N Amt 1 2 3 88888 10 1 2 3 88888 12 ------so on----------------------------- 1 2 3 88889 2 1 2 3 88889 3 ---------so on--------------------------- more than 10000 called_num for this group (1,2,3) 1 3 3 77777 10 1 3 3 77777 12 ------so o...

Hi There, I am using aggregator to do the sum of values. The data set looks like Account_Key, Service_Key, Period_Key, Called_Num,Charge_Amt I am aggregating by Charge_Amt For Account_Key, Service_Key, Period_Key group there are more than 10000 Called_Num. and there are several Service_Key for Accou...

Thanks for the advice.
I am doing like this only.
I am just wondering that is there any property where I could put this defalut value and do not have to split and merge data.

Regards,
Munish

Hi Everybody, In one of my Load job (to Oracle) I need to do lookup to find the key (from dimension table) and load the target table with the key values ie I am getting Account_Num as input and I need Account_Key for output. Now if Account_Num does not exist, I do not want to reject my rows but cont...

Hi Ray,
We are using Datastage 7.5.2,
Which version is compatible with encrypted password env variables.

Or
Do I need some plugin?

Thanks and regards,
Munish

Hi, '$PROJDEF' is working fine. However it is not working with Passwords. For encrupted password environmen variable, I have to delete and reload the environment variable. Any Thoughts !!!! As for Narasimha, I am not sure why it did not worked initially. I restarted my Datastage and it was bang on. ...

Hi,
I faced the same problem but get it sorted out using '$PROJDEF'.
However, '$PROJDEF' doesnot work with passwords.

Any suggestions !!!!

Thanks
Munish

Thanks Everybody,
It worked fine.
Regards,
Munish

Hi,
I tried using $PROJDEF as default but DS takes it as string.
Is there anything else to do other than writing $PROJDEF for default value.

Thanks,
Munish

Thanks, I will give it a go.

Regards,
Munish

Thanks Narasimha,
We were using hard coded value.
We have about 12 different env variable.
So if one job is using all of these variables
we should have $PROJDEF as default for every variable.

Cheers,
Munish

I tried that, but it is the same.

There are more than 50 odd jobs which will be using this variable.
If I delete and re-insert env variable, I could see new values otherwise it stores old value.

Still not sure, what might be happening.

Any other thoughts!!!!

Hi Everybody, We are using environment variables for 1. Database related values like Server Name, UserID, Password etc. 2. Files related activities, InputPath, Out Put Path etc. Everything was fine till now. We were expecting that we can modify the values of Env values and that can be reflected in o...