DSXchange

Hi, I have a requirement to process multiple file (of the same pattern) and notify to the support group in case of failure or if the job is completed successfully To achieve this functionality I am using a start loop and end loop activity in my sequence job , issue is how do I send an email after su...

rkashyap wrote:See the link for a workaround ...

viewtopic.php?t=118685

Thanks a lot for the information.. I will try this out...

So why not use the Enterprise stage? Did you try it and have issues? I tried Pivot enterprise stage , there is a property where in we can select the Pivot type as vertical or horizontal but when we select vertical the other options (which should be applicable for vertical pivoting) doesn't change.....

Hi, I wanted to do vertical pivot on incoming data . I am using datastage 8.1 version and it seems vertical pivot is not supported in this version (although there is an option to select pivot type as vertical in the Pivot Enterprise stage) :( My Input will look some thing like this : Col1,Col2 1,A 1...

try using a trim() for column SITE_DESC in both your source and reference sql query

Hi,

I had a query in parallel jobs RCP functionality

What is the use of Run time column propagation ? Is it mandatory to use it in parallel jobs ? what is the impact if RCP is disabled in a parallel job involving oracle connector stage ?

Thanks a lot for the information...

Hi all, I am new to datastage, I wanted to understand datastage architecture in detail and how it is integrated with other components in the information server I tried to check the same in IBM site but the information was scattered Can you please share any link or tutorial which talks about the arch...