DSXchange

Actually this warning appears after 2 Hrs itself.(i.e from the moment you start the job)

Actually you are right, the job actually took 14 Hrs, just now i checked.
Is there anything i can do to avoid this warning?

Hint...: - The Job actually runs 12 hrs, which is correct according to the estimate.

Is this because of space issue?

I am getting the below warnings, any idea what is this?

buffer(2),0: APT_BufferOperator warning: currentWriteTime <= lastWriteTime, 1254870770.10021 1254870770.47596

The below mentioned article is for the Jobs i.e the PL/SQL programs created in Database. Not suitable for DataStage Jobs.
It would be more complex if we take this as the starting point to solve the above query.

And also keep the column size as nothing, it should work fine.

I guess you cannot call a DS job in a DB trigger all you can do is write a shell script where in you can connect to DB query based on the result run your job, and schedule this script on cron or on control-M,

i have no idea about Control-o.

Thanks

I have already got the logic working, by defining more columns than required in transformer, And after that i have more complex rules applied....so i am justing keeping those things seperate to avoid confusion. 2. If first line has 2 embedded fields and next has 10, how will you decide how many colu...

it has a delimeter, please see the first question asked initially.

Please see the questiona again, i dont have problems with pivoting,
i want to calculcate how many values are there in an array and accordingly i have to put each of them in seperate columns(which has its own derivation), in the end i am funnelling.

i have two columns


A B

1 gfg gfg kzl dsk gdg
2 hdh hdh
3 dhd dhd hdh jdk jdj jdj kjd


column B values will be further derived and added in the end, doing group by column A.

Thanks

Yes Kind of Srividya,

I am defining n no of columns in transformer and after that i am funneling all the values so that it goes to one column, but in between i should apply different rules i wll have to treat my source column with many values as some array.

I assumed it cannot go more than 20 values like that and coded accordingly, its working but i wanted to code dynamically.

No

we are not sure how many columns we get...!

Hi Folks, In one column i have data like this, hsd sdj hds ddh sdh hsd hsd djd ggh hsd jsd i have to derive columns based on the delimeter, but the no of columns are dynamic, lets say we can find out the number of columns coming thru in each record. So is there any way of assigning each value to the...