DSXchange

Thank You everyone for your expert suggestions,

I am closing this thread with the below solution as the optimal one,

TXF (5 o/p links)==>5 IPC ==> Link Collector ==> Seq. File TXF

Warm regards,

We have these jobs for almost 40 countries(hence 40 jobs/module, we have number of modules and design is generic) and considering the volume of records, i personally felt that its better we have a design which occupies less phyical space, please correct me if i am wrong in my thoughts. Even though w...

Hi Rejith, Thanks for your thoughts, I am not sure if it will work, but I feel that the usage of hashfile (which is gonna occupy physical memory) for this scenario is not an apt and optimal solution,

can't we derive the output on the fly ??

Hi,
Thanks for the response.
But IPC does cannot take more than 1 input,
hence

TXF ==>(Cannot take more than 1 Input) IPC ==> Link Collector ==> Seq. File

will not work,

Any other suggestion pls.

Thanks

Hi, I have a transformer which provides 5 output links each having the same metadata. I need to horinatally join all the records into a single link. Basically i am trying to achieve the funnel stage functionality of PX flavour, I tried TRANFORMER ===> Link Collector ==> Seq. File , but obviously it ...

hi everybody,
i am doing a server job where my input is sequencial file the the record delimeter is(Ctrl+a) .Can datastage sequencial file read these kind or records?
Thanks in advance

hi all, i am having some problem when i am calling a shell script form datastage. i have a shell script which is in /home/devinput. name of the shell script is "test.sh" now i am calling this shell script from job properties "before job subrutine".In "before job subrutine&q...

hi all, i am having some problem when i am calling a shell script form datastage. i have a shell script which is in /home/devinput. name of the shell script is "test.sh" now i am calling this shell script from job properties "before job subrutine".In "before job subrutine&qu...

Hi,

In our process,First job will load approx. 4-5 GB of data in a dataset.And in the second job, i have to use the above data set as source.
Will Dataset handle that much data or any limitations to that ?

Thanks in Advance,
Kishore

Our requirement is that we need to pass only those records, within which a column is less than a particular value, for instance 10. But this 10 has to be parameterised, and this value is a result of a SQL query.

Any help will be highly appreciated.

hi,
Is it possible to specify the output of SQL Query in the WHERE Property of Filter stage?

Hi, I am trying to run five jobs parallely in a job sequence..but i am getting the error like "Resource temporarily unavailable".But when i am running all these jobs sequnetially, then there is no problem. All jobs are running fine.But i am not able to acheive parallelism.I also heard that...

Hi, I am trying to load data in a sybase table using Sybase stage.But i am getting the following error. main_program: Fatal Error: Fatal: Shared library (sybaseoc.so) failed to load: errno = (2), system message = ( 0509-022 Cannot load module /opt/Ascential/DataStage/DSEngine/lib/sybaseoc.so. 0509-1...

Hi, I am trying to load data in a sybase table using Sybase stage.But i am getting the following error. main_program: Fatal Error: Fatal: Shared library (sybaseoc.so) failed to load: errno = (2), system message = ( 0509-022 Cannot load module /opt/Ascential/DataStage/DSEngine/lib/sybaseoc.so. 0509-1...

hi all,
i am working in datastage parallel extender from last 4 months but i want to know how the transformer internally work in datastage .i tried to find out documents regarding this topic but i am not able to get any meterial .so can anybody help me regarding this issue.
Thanks in advance