DSXchange

I think craig's idea is good.. I had implemented similar stuff in my project and it works... Instead of having a big data file, have multiple flat files based on a key, in my case it was employee_id, partition the table on this key, and then run multiple instances of the same job to load this data i...

Why are you not using the "order by" clause in the query itself ..

Did you contact your support teams to make sure that all the TNS entries are defined on the server ?

I dont think that's possible. You need to have a output link from the ODBC stage to execute the SQL

pradkumar wrote:Thanks

Did it work ??

This has nothing to do with the upadte action you are performing on the table. For the sequencer to process sucessfully even if the jobs that it is calling finish with warning, you need to change the properties of the job activities present in the sequencer. In the properties of the job activity the...

My requirement is osmething different. There are certain columns which when null should have the value of the colno-1..If the col(x) is null then i am entering NA then if col(x+1) is also null, it should be NA. Hope I am clear now For the above mentioned requirement, the transformation should be If...

Please post the exact transformation that you are doing, it cant be if isnull(in.col2) then (in.col1) else enter default value of col2 I would suggest the following code, if isnull(in.col2) then (in.col1) else 'NA' However this doesn't look logically correct to me. It should be something like if isn...

In the sequencer, go and right click on the job activity that is failing. Go to its properties, you will find a tab called triggers, change that.

Change the trigger to
JobA.$JobStatus = DSJS.RUNOK Or JobA.$JobStatus = DSJS.RUNWARN

I need to list the names of all the files present in 2 different folders at the unix box in 2 files and then mail these files as attachements. I am using notification activity to send this mail. I have 381 files present in one folder and 1 file in the second one. The problem is that the file that co...

Thanks Craig..

I am inserting data in DB2 table and I have set transactional handling as 0 to rollback in case the load doesnt finish sucessfully. My question is whether rollback will take place only if the job fails/aborts or even if the job finishes with warnings ?

Thanks

You can use the following transformation to get the date.

Oconv(Month.Last(DSLink3.date),"D DMY[,A,]")

The date supplied is in YYYY-MM format. You can change the format of date for the output.

Have you set the delimiter as '|', by deafault it is set be a comma(,) ?