DSXchange

Well with the function i gave using FMT my field is promo_id and the value initially was 3453 but after i gave the function FMT(Promo_id,"8'0'R")
the value it shows is something like this 34u`5

well the field is of type decimal

Hi All, Well i have this job in which i am supposed to the pad the field with zeros at the begginging. as in the field is actually of length 4 but i need to make it a length of 8 where in the missing characters should be zeros and i need to add these zeros at the begginging. i can actually just do w...

Well i did check and the foreign key value is same as the primary key value of the other table . as i already told you i have two oracle tables to be loaded . one of them which gets loaded twice is ETQ.VALIDATION_VALUES which has 8 fields PROCESS_ID SUB_PROCESS_ID MEASUREMENT_ID PROCESS_TIMESTAMP SU...

Hi All, well i have this job where i am loading the input row count and out put row count into a table as separate record (ie i am loading the oracle table twice once with input row count n later with output row count). the oracle table has 8 fileds of which first 4 are hard coded and they are the p...

Hi All, Well i have this file which was created in another job which was created in server job . this file has the delimiter as | and quote character as 000. i'm need to use this file in the parallel job . i tried giving the delimiter as blank and quote as blank but no luck it says delimiter for one...

Thank you very much . that worked ...
and i changed the name of the routine too...

Thanks once again

Yes i am talking about the job sequence.
i'm sorry if i have used wrong terms in addressing my problem .
i am doing a job sequence here.

i apologise once again for any confusion wht so ever.

Could somebody help me with this now.

Thanks in advance

Server job

for one of the notification my trigger is Failed(Conditional) for notify when the second job fails completely the for the second nitification my trigger UserStatus(Conditional) and in the expression i have given = '1' well my code in the routine is like this Function SetUserStatus( V1 , V2, V3) if V...

well i have written the routine and i called the routine in my second job (ie the final job) i actually called the routine in the stage variable but i am not mapping that to any field in the output . . now in my sequencer at the final job i have given two notification, one for failure of second job ...

Well could you please help me in doin this cause i have really not used subroutines . could you please guide me with the steps...

Hi All, Well i have this sequencer which consists of two jobs . the first job actually does all the transformation and finally loads two files. one which holds the output values and the other which gets the input and outpur row count. in my second job i'm doin balancing logic . ie here i join those ...

well i have actually done a job in which my source was from the mainframe . after all the transformation i put the result into a seq file . well now i'm trying to load the meta data from that output seq file . but when i save that metadata it doesnt show any level number but when i load it into my c...

Hi all, Well i have a problem loading the metadata. when i try loading the metadata it loads along with the level number as all my data are coming from mainframe file . but i dont require the level number . now how do i load the metadata without the level number Can anobody plz help me with this iss...

Well i have this job where in i need to make the transformer wait for the file that is written in the same same job . the req i have is that i need the count of the records getting into the output file and at the same time i need to extract the input record count from the input file and load both of...