Search found 1724 matches
- Mon Jun 11, 2007 8:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error fetching data using Oracle Enterprise stage
- Replies: 4
- Views: 3784
error fetching data using Oracle Enterprise stage
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...
- Mon Jun 11, 2007 8:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: C++ compiler
- Replies: 2
- Views: 1653
C++ compiler
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
I have installed DataStage 7.5x2 EE but dont know which C++ compiler should be installed.
thanks & regards
- Thu May 24, 2007 5:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Incremental loding and Incremental load
- Replies: 5
- Views: 2689
Re: Incremental loding and Incremental load
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...
- Thu May 24, 2007 5:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Preserve sort Order
- Replies: 2
- Views: 1449
Re: Preserve sort Order
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...
- Mon May 07, 2007 4:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem in implementing pivot stage
- Replies: 11
- Views: 4500
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 ...
- Thu May 03, 2007 4:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem in implementing pivot stage
- Replies: 11
- Views: 4500
- Thu May 03, 2007 1:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem in implementing pivot stage
- Replies: 11
- Views: 4500
- Wed May 02, 2007 11:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem in implementing pivot stage
- Replies: 11
- Views: 4500
Re: problem in implementing pivot stage
yes, I am getting error while dragging the link from pivot to oracle.
- Mon Apr 30, 2007 5:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem in implementing pivot stage
- Replies: 11
- Views: 4500
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...
- Mon Apr 30, 2007 5:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem in implementing pivot stage
- Replies: 11
- Views: 4500
problem in implementing pivot stage
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...
- Wed Apr 18, 2007 5:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSGetStageInfo in Parallel job
- Replies: 14
- Views: 7578
Re: DSGetStageInfo in Parallel job
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...
- Wed Apr 18, 2007 3:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSGetStageInfo in Parallel job
- Replies: 14
- Views: 7578
Re: DSGetStageInfo in Parallel job
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...
- Tue Apr 17, 2007 11:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Can we export joblog to a file
- Replies: 27
- Views: 16090
Re: Can we export joblog to a file
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...
- Fri Apr 13, 2007 6:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Time stamp conversion
- Replies: 1
- Views: 1165
Time stamp conversion
what are the differences between sql server timestamp and oracle 10g time stamp?
How to implement the conversion on datastage 7.5?
How to implement the conversion on datastage 7.5?