DSXchange

Ray,
I am trying to create Surrogate keys...in PX.

SKeyiniVAR=@PARTITIONNUM
SKeyiniVAR=(SKeyiniVAR + @NUMPARTITIONS) -> Skey

I am able to see that the values of @ systems variables are good.
@PARTITIONNUM= 0,1,2
@NUMPARTITIONS=3

I am trying to initialize a stage variable and trying to change it in the transform-stage of PX. iniVAR=@A (initialized in the tranformer stage) I have a field 'out' in the transformer stage and am assigning the following to it: iniVAR=(iniVAR + @B) I am writing the 'out' field to a file, when i loo...

I have gone through your comments on it on the Forum...I just wanted to try to update a Hash Stage.

Thank You

Thank YOu for the info... I have a small sample job which does CDC using CRC code... I have input data coming in to a transformer, which also has a reference link(Hash Stage)...i m outputting data from the transformer into matchfile(record exists) & unmatched file(record doesnt exists), (both SE...

Is there a way we can update the Hash File in Server Job which is used as a reference. Say, I am using a Transformer Stage with main input and reference input link from the Hash Stage...Can I use a link(not reference link) back to the Hash Stage and update the data if a NEW record has come in??? The...

What do u mean by SEEDING value? I will be needing: -MAX value from the table -APT_PARTITION_COUNT -APT_PARTITION_NUMBER -incremental number(1 here) HOpe the APT_* variables are declared in the ENV and can get using the ENV variables...I read some where in the doc's of Ascential that we cannot use $...

I have not decided what to use for surrogate keys...just exploring different feasible options i can finalize on later...There is always those things when we deal with storing things in a file...But i guess the DS process of key-management is using the hash-files to store the value to be retrieved fo...

Well Sure...is there a way I can figure it out and store the value in a file at the end of day's processing so that i dont have to use DB queries to select the MAX...i guess the funtion in DS (key-management) uses this kind of concept... I can read the MAX value previously written to the file and re...

Thank You for confirming that gaps in the keys dont matter if used only for uniqueness... Also, If I have to store the last key (index) generated for a run how would i do it?...meaning will I be able to figure out which is the last value generated from the key generation...so that i can start my nex...

Following ur way to generate surrogate keys... I guess u have assumed number of records in the each partition to be EQUAL, which is NOT the case most of the time when we sort & partition(with using different partitions) the records. If we dont get EQUAL number of records in each partition, we wi...

Thank You Vincent for your feedback...

Ray, Can you please elaborate on the what kind of UNIX based scripts are you talking about?

Thank You for your feedback...
Presently I am putting some doc together to make sure the ENV is set GOOD for the Dev/Test/Prod machines.

Can anyone plz let me know if there is a checklist to make sure that: 1. DS-server and PX-server works 2. all the environment is in GOOD working condition 3. We are using DS, PX, QS, MS...so is there a way to make sure that they can interact with each other without a problem Eg: To make sure Px is w...

Thanks for the feedback... Do you know if we can use QS plugin for PX jobs...when i tried to add the QS plugin in the PX-job pallette...it shows them on the pallette...BUT THEY ARE DISABLED... When i open the server-job, i can see them enabled there... Is the plugin for only DS...is the plugin not c...