DSXchange

If only the newly added columns need to do lookup or transformation, you can try with lot of pre scripting. Just have three delimiterd varchar column defined in job. Spot the added column by script and add delimiter only that column and concatinate or add different delimiter to the rest of the colum...

Work out in reverse order. Sort it in desending.
You can do this using some stage variable in transformer.
Something like this,


Asign val_b to d.

what is the desinged that you followed to create a uniform staging file?
Will seperate file stage look for each file?
If so to a touch in before job subroutine on each file before starting. So that, even if that file not present, the job can run with processing the empty file.

Best to have a Center Stage, with inner join on the Pacific.

Welcome to Dsxchange!!!

You can schedule the job with a frequent interval, which actually first looks for the availability for all the files. If not quits after the check. If found, proceeds the process. :D

Check if dt_saisie has data for current data and for the given condition.

Strange to see file names declared in Administrator.
Reg txt, dont declare .txt in variable declaration.
eg: #$first_out# = first

cp #$OutputPath##$first_out#.txt #$OutputPath##$first_out#_`date +%Y%m%d`.txt

One disadvantage of stage left is that, it need to do a clean and boost up for every saturday nights.

What is the customization you are expecting?

No Need to hardcode, you parameter will work as it is. Avoid the $, unless given in the variable name.

cp #InputPath##first_in# #OutputPath##first_out#

Select the table that contain the policy_no thorugh a oracle stage and link it to the ODBC stage which calls the stroed procedure. The output of the OCI will the input for the ODBC.

Is all you input columns been propagated to output of the SORT stage. If you want to select only the required column, use transformer stage.

If you want to calculate the ouput record to seq file1 or seq file2, use @OUTROWNUM. If you want to get the count on total record that extracted by oracle stage, use @INROWNUM.

CFF stage is built effeciently to handle this type of data. If you able to provide the layout or the copybook, it will be easiest for you.

I couldnt check Vincent's recent blog related to TubeCast with my 64Kbps. I guess its something related to this release that too by next few months.