DSXchange

Can anyone help me with above issue.

No,Header and trailer is changing in every job run.

Thanks FranklinE!

Its better idea.

Hi, Since distribution of records in transformer is not in order hence my formula to generated sequence number in transformer is missing some sequences and i dont know if there is any chance of getting duplicate in sequence number. According to my understanding,datastage round robin partition should...

Hi, I have a job where source is dataset and after that i have a transformer where i am generatting a sequence number so on the input link of transformer i have explicitly defined round robin to avoid and holes in the sequence number,but its not working properly. I am running job in 4 nodes configur...

Hi,
I have tested the parallel read with this logic but it seems data is duplicated in other partitions.

Hi,

Blob datatype is not supported in datastage,but if your target datatype is varchar you can typecast using StringToRaw function.

I think convert function will work here.Test this function and let us know.

Hi, I got a requirment where i am getting a flat file and i need to add header and trailer to that file which later ftped to another server. I designed a job like this. Header --------------------> Sequential file -----------> Trailer----------------------> Funnel(Sequence) -------->Target File Here...

Hi, I am also using same kind of routine to log a failed event notification. I dont understand exactly what you are trying to do.I will explain what i am doing in my sequence. In my sequence i call first Job and once it is failed i call another generic job where i pass this routing with failed job n...

Hi,

You can use join stage of type inner and your joining key will be transaction key.

What is your input and output datatypes in transformer.

Thanks Craig.

Hi, I am trying to develop a design where table should be truncated if my main job fails in loading. I am thinking to design a job to truncate a table. Rowgen------> oracle connector stage Now I am stuck here, since there is no option to truncate table (instead we have delete option) in connector st...

Define key Columns in output connector metadata.