DSXchange

If there are no gaps, then my MIN and MAX solution is good. And faster. Especially if these columns are indexed with B-tree indexes. Thanks Ray. I used the lag and lead Oracle analytic functions to derive the desired results . I need to test it for huge volume and am happy to share if any one needs...

Funnel stage will bring them back together. But I think LAG is the optimum solution - what if there is more than one gap in the dates? Hi, Ray, I dont think there will be gaps in the dates as the data has already been processed as monthly and we have all the months . I think it's a trade off betwee...

Hi Ray, I missed the last set of records in the above example i.e. ------------------- Current data : ------------------- Name : xyz State : new york Start Date :01-JAN-2009 End Date :31-JAN-2009 Name : xyz State : new york Start Date :01-FEB2009 End Date :28-FEB-2009 Name : xyz State : Mass Start D...

Hi, I have a requirement where in the monthly data needs to be rolled up based on a set of key columns into an SCD format . Per the below example : Database : Oracle Key column : Name,State Current data : ------------------- Name : xyz State : new york Start Date :01-JAN-2009 End Date :31-JAN-2009 N...

Hi, I need to trigger a sequence automatically if any file arrives in a particluar directory.Whil running the file will be deleted by sequence. Once the sequence gets completed again it has to wait for files in th same directory. How can I achieve this ? Hi, You can have a master sequence and use t...

Just as Chulett said you need to create a VOC entry using the SETFILE command

SETFILE <pathname> <VOC Name> and
then do a COUNT <VOC Name>

A search on Write failed for record id would have provided you with the solution . Here is my bit in helping you out ..

http://dsxchange.com/viewtopic.php?t=11 ... ce9937713d

Hi, Looks like its an Oracle error, and the following is the explanation for the same ora 32512 : // *Cause: trying to dump an invalid type name // *Action: specify a known type Can you try to load the text file directly using sqlloader without datastage to see if the issue persists. Regards, Vinod

Can you try to delete and reimport the job . Also, just to be sure per the aforesaid notes does the job compile if you change the name of the same .

Alternately after your job failure/completion run the command or create a shell script where in the job name,project name is passed dynamically with the following command in the shell script ... dsjob -logsum <project name> <job name> Have a Notification activity stage which attaches this log file. ...

SCD is a regular stage type, it sits right there in the processing stream. ... Is SCD available in V7.2 ? or just from V8.0 onwards ? Nope.SCD is available from V8.0 only . In case you need to implement SCD in the previous versions u can do so with the help of change capture and transformer stages ...

Hi,
It could also be that the job has an internal lock. Try to re-compile after clearing the status file and do post the error you get .

Hi,

Please check the below link,its not the exact requirement but can help you to think more on the same line,hope it helps !.
http://dsxchange.com/viewtopic.php?t=96 ... c63ff43e05

Hi,
Can you check the dataypes that was specified, just to make sure. I tried to mimic the same scenario and worked for me without any issues.
Regards,
Vinod

Hi,
Can you provide more information about your job design .
Regards,
Vinod