DSXchange

do we need to grant Select privilage to sys.dba_extents while fetching data using Oracle enterprise stage and why? Because I can fetch the data using ODBC stage but while fetching data from Oracle enterprise stage i am getting an error like Error executing View Data command: ##E TDOR 000172 17:47:30...

Which C++ compiler will be suitable to compile the transformer stage of datastage 7.5x2 ?

I have installed DataStage 7.5x2 EE but dont know which C++ compiler should be installed.

thanks & regards

Hi Every one, I would kindly like to know, What is incremental loding? Can all the loading which will increment or update the target can be considered as incremental loading. So in that case In Datawarehousing we always go for incremental loading. One more question. What is incremental load? Is tha...

Hi All, What is use of Preserve Sort Order option in Transform Stage In PX? Please help me for the same. Thanks, KKSR Assume that u want to perform sort based on the values of two attributes a & b if your incoming data is already sorted wrt attribute a now when u use preserve sort order it wont...

My guess is that you already have an output link from the Pivot stage (look carefully for any red color) which is why Designer will not let you draw a second output link from this stage. ... I can't see any output link. for that i have compiled the job, the error is: there must be an stream output ...

ray.wurlod wrote:For a mere few cents per day you can be a premium member and help to fund the bandwidth costs of DSXchange.

I will try to get premium membership but help me to solve this problem, my case study can not be completed without implementing that stage.

ray.wurlod wrote:I infer from your note that the error occurs when dragging a link from the Pivot stage to the downstream Oracle Enterprise stage. Is this correct?

I was not able to reproduce this problem using ve ...

Since I am not a premium member, I am unable to see the whole reply.

yes, I am getting error while dragging the link from pivot to oracle.

Tell us ALL the stages in your job design (draw us a picture), and at precisely what point in the job design that this error occurs. ... I have a CSV file as input in which address field is to be broken in different fields after removing control characters using unix cron i am reading the input fro...

I have installed datastage few days back. when I am trying to implement pivot stage, I am getting error message as: (40822) The source stage does not suppot output links. but pivot stage must have one stream output link. I tried to find the cause of error but unable to find it? Please suggest the ca...

Hi All, I have requirement where I need to derive the data corresponding to the row number. Same thing was achieved in server job using DSGetStageInfo(DSJ.ME, DSJ.ME, DSJ.STAGEINROWNUM) in the constraint of the transformer stage but as DSGetStageInfo is not there in the parallel job, how can the sa...

Hi All, I have requirement where I need to derive the data corresponding to the row number. Same thing was achieved in server job using DSGetStageInfo(DSJ.ME, DSJ.ME, DSJ.STAGEINROWNUM) in the constraint of the transformer stage but as DSGetStageInfo is not there in the parallel job, how can the sa...

Hi All, Can we export/save the joblog or job status to a file?? I want to use that file in some other application so that i can derive the elapsed time of the job and other details. I just want to take the information about the job out of DataStage application... Please reply... Thanks in Adv.. Reg...

what are the differences between sql server timestamp and oracle 10g time stamp?

How to implement the conversion on datastage 7.5?