DSXchange

There is no Pivot Stage in my Pallette!!???
I am using DataStage 7.1

I have the following requirement...

My Input is:

A1|b1|b2|b3
A2|b4|b5

The Output should be:

A1|b1
A1|b2
A1|b3
A2|b4
A2|b5

Is there a way to do this on the Parallel canvas?

TiA

DSHOME=/ascential/dsadm/Ascential/DataStage/DSEngine; export DSHOME APT_ORCHHOME=/ascential/dsadm/Ascential/DataStage/PXEngine; export APT_ORCHHOME UDTHOME=/ascential/dsadm/Ascential/DataStage/ud41; export UDTHOME UDTBIN=/ascential/dsadm/Ascential/DataStage/ud41/bin; export UDTBIN ODBCINI=$DSHOME/.o...

$ ivtestlib /ascential/dsadm/Ascential/DataStage/DSEngine/lib/infmxcli.sl /usr/lib/dld.sl: Can't open shared library: /u1/informix-sdk/lib/cli/libifdmr.sl /usr/lib/dld.sl: No such file or directory Load of /ascential/dsadm/Ascential/DataStage/DSEngine/lib/infmxcli.sl failed, errno(2)=No such file o...

Hi
View Data says:
ds_loadlibrary: error in dlopen - Dynamic Error

My environment has it...
SHLIB_PATH=blah blah blah ... :/ascential/dsadm/Ascential/DataStage/DSEngine/lib: ... blah blah blah

Hi I am trying to use an Informix CLI Stage instead of ODBC Stages to improve performance. But I am getting the following error... Project:Dummy (gizmo.apis.dhl.com) Job name:testInformix Event #:58 Timestamp:4/1/2005 5:11:37 PM Event type:Fatal User:itkadm Message: main_program: Fatal Error: Fatal:...

Hi
I've worked on a lot of work-arounds over the couple of weeks. They are true work-arounds. Can you tell me how I can integrate a sequential file stage with a BuildOp so that I can change the file name based on the value of a particular field? TIA

As of now, I am using multiple instances, but I'd love to use to custom stages, but do not know how to use them.
Does anyone have any documentation or Knowledge articles on how to write customstages and buildops?

Hey Ray,
That was some real cool info.
I need that more than anything else.
Thank you.

I was able to find out that this error is occurring after the first few runs, and only IF there is a Join stage in the canvas!

Can someone throw some light on this...?
TiA

There are two parameters...
one specifies the segment I am supposed to extract.
the other specifies the file into which the row has to go.
the job control calls multple sequence of the job with different parameters...

Thanks a lot anyways.
If I figure it out, I'll let you know...

It is Ticked and Disabled!
How do I enable it so that I can UnTick it???

are you referring to runtime column propagation?
if yes, it is turned off in the administrator for this project.
if no, how do i do that?

This is how my job is... left_table ----\ left outer join--- right_table ---/ bath tables have 29 columns (same columns) Only 1 column is the key - parent_id I've renamed the columns (except parent_id) in the right_table within a transformer as 'c_'columnName Is there anything else I should do???

But no,
I've renamed the columns that are not part of the key in the second stage as c_columnname