DSXchange

Hi All, i have this job where i need to do a self join on one table based on one column and then join it to another table based on another column. here is what i have done i get the data from a complex flat file (CFF) and the output link goes to the Transformer and also to the hash file. in the hash...

i tried using the TX3 but still the same error while compiling

Hi All, i have this job where in the input data is coming from a complex flat file and it goes to an transformer. from the transformer i am giving two outputs by giving constraints well one output goes to another transformer and the other goes to an agg where i count the record for that particular c...

well i tried all possible combinations of primary keys . but still it doesn't work . well i have process_id subprocess_id measurement_id processtimestamp subprocesstimestamp measurementtimestamp measurement_value measurement_result of which most of the fields have values hardcoded it is just the pro...

Thanks guys. it worked

Hi All, Well i have an issue here with the trim function. i have this filed which looks like this 000000000205935. This field is actually the record count fo the file and it is of length 15 . well now i want to get only the actualy record count as in i need to get rid of the zero's which are at the ...

well i have tried loading into sequential file and the conversion looks fine .
Any other suggestions?

well as i already mentioned the filed i want to load in oracle is of the format 2006-11-30-10.28.15.817238 and of type char (26) i formatted this field in the follwoing way Left(l_to_Tform.BMC_TS,19) Trim(DateFormat,"-","A") Trim(TrimD1,".","A") TrimD2 [1,4] :...

well the length is 38 itself .
is there ant other problem that you could think about ?

i have a field in my job which is in the format 2006-11-30-10.28.15.817238 and the data type for this field is Char(26) and the field in Oracle table is of the format 2006-12-01 16:23:11 and the data type is Timestamp well i have formatted my field in the job to the format in oracle by removing the ...