DSXchange

I have created a datastage job which takes around 5 MILLION records as input . One of the columns of this dataset is ADDRESS_ID (Varchar type, max length 100 chars). In the later stages of the job, there is a join stage which joins the input data with another reference dataset ( of comparable data v...

I had a couple of questions . 1. Is the loop executed ahead of the evaluation of the stage vairables,for a single input record ? 2. The Stage Variable NumSavedRows cannot be set to SaveInputRecord() because a correponding GetSavedInputRecord() needs to invoked , and that too within a loop variable ....

Hi there, Thanks for responding ..... There are lots of stuffs related to transfomer looping, that I wasnt able to decipher, especially the examples mentioned in the link below: http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ds.parjob.dev.doc%2Ftopics%2F...

Maybe it would sound like something that has been already asked in many previous topics , but I am LITERALLY running out of sorts to understand how exactly the loop structure works in Transformers stages . I am posting this after being utterly confused by the facts given in the IBM Online manuals of...

Sorry , my bad ...... ..... Probably because I'm a first time user ..... But, I dont really see the Reply to topic button in my login ........

Anyways , thanks for the info.....

Thanks again. But, the things which I didn't understand are : a) How could you increment the value of the stage variable svCounter for EACH GROUP (MEMBER-PHONE) ? The reason fo asking so is , how could a Transformer stage identify each unique group of MEMBER-PHONE ? b) Why should I increment the val...

Thanks for the reply Rajan.

I understood the first part, but things start to mess up from the point where you have mentioned "Code your transformer logic to filter out all the records in a group....".
Could you please elaborate ?

Thanks in advance,
Kumarjit.

Hi,
Is there any other way of unlocking a Datatstage Parallel job than using DS Adminstrator Client ?
Please share your thoughts.
Tried all ways known , but to no avail.

Thanks,
Kumarjit.

Hi there , I am having a set of data with three columns : 1. MEMBER (varchar) 2. PHONE (varchar) 3. UPDATE_TIME (timestamp) The data looks something like this below : M1 P1 T1 M1 P1 T7 M1 P1 T1 M1 P1 T1 M2 P2 T8 M2 P2 T2 M2 P2 T6 M2 P2 T2 where M's stand for MEMBER, P's stand for PHONE and T's stand...