Hi Team,
How to perform RANGE LOOKUP In server job, without using Enterprise or UV stage.
Thanks In Advance
Search found 75 matches
- Fri May 04, 2018 3:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: perform Range Lookup in server job
- Replies: 2
- Views: 15954
- Mon Apr 16, 2012 4:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job aborted with Fatal Error: Table Loaded Successfully
- Replies: 1
- Views: 2100
Job aborted with Fatal Error: Table Loaded Successfully
I ma trying to load data from a file into a Netezza Table. The job is getting aborted with the fatal error : Table loaded Successfully. When I queried the table, data is getting loaded there, but the job is getting aborted . Please find below the error messages from the Director Log: Netezza_Enterpr...
- Mon Mar 26, 2012 11:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NZORCH tables not getting Dropped Post DS Job execution
- Replies: 2
- Views: 3399
- Mon Mar 26, 2012 8:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NZORCH tables not getting Dropped Post DS Job execution
- Replies: 2
- Views: 3399
NZORCH tables not getting Dropped Post DS Job execution
Hi All, We are using Datastage with Netezza Combination. We use Netezza Enterprise stage to load data in Netezza tables. While loading data, Datastage creates external tables in between the process. These tables have names starting with 'NZORCH'. Even after the process finish successfully, DS do not...
- Sun Mar 25, 2012 7:21 am
- Forum: General
- Topic: Parameter Setting in Sequence showing Error
- Replies: 11
- Views: 6856
- Sun Mar 25, 2012 4:56 am
- Forum: General
- Topic: Parameter Setting in Sequence showing Error
- Replies: 11
- Views: 6856
- Sat Mar 24, 2012 8:50 pm
- Forum: General
- Topic: Parameter Setting in Sequence showing Error
- Replies: 11
- Views: 6856
- Sat Mar 24, 2012 7:47 am
- Forum: General
- Topic: Parameter Setting in Sequence showing Error
- Replies: 11
- Views: 6856
- Sat Mar 24, 2012 6:01 am
- Forum: General
- Topic: Parameter Setting in Sequence showing Error
- Replies: 11
- Views: 6856
Hi Ray, Thanks for your reply. I think I am stuck with a big problem here then. We have created a project level parameter set where we have created all the parameters which we are using in any job. For example I have 10 jobs. If every job is using one parameter then all those parameters are created ...
- Fri Mar 23, 2012 5:45 am
- Forum: General
- Topic: Parameter Setting in Sequence showing Error
- Replies: 11
- Views: 6856
Parameter Setting in Sequence showing Error
Hi, I am creating a sequence and when I set Parameter value as SetTodefault I am not able to change the value of any parameter at run time. However If I change this option to 'Insert Parameter' my sequnece aborts with a warning "Error calling DSSetParam(iConnect.JPM_WK_SAP_XREF_FILE_DT), code=-...
- Thu Oct 20, 2011 12:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Integer Conversion
- Replies: 2
- Views: 3911
String to Integer Conversion
Hi All, I am trying to load one Flat file toNetezza database. In flat file, I have a column as Varchar and in Target the datatype of column is Integer. I am not using any function for explicit conversion in between. Now if I have data as 1234, it gets loaded correctly. But when I have data like 'abc...
- Sat Oct 15, 2011 3:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Run Options
- Replies: 3
- Views: 2716
- Sat Oct 15, 2011 12:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Run Options
- Replies: 3
- Views: 2716
Job Run Options
Hi All,
I was trying to run a job in Datastage 8.5 Enterprise Edition and could not see limit number of rows option enabled while running. Is this feature only in Server edition?
Thanks.
I was trying to run a job in Datastage 8.5 Enterprise Edition and could not see limit number of rows option enabled while running. Is this feature only in Server edition?
Thanks.
- Thu Oct 13, 2011 3:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Link Ordering
- Replies: 7
- Views: 5749
- Thu Oct 13, 2011 10:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Link Ordering
- Replies: 7
- Views: 5749
Re: Link Ordering
Thanks for your reply. For link ordering, I opened transformer and moved the delete link to the top with Array Size of 1 and a Transaction Size of 1. But when I run the job, it deletes all the records. Here is an example of current scenario Src File ID Name A1 Abc Initial Load into target Skey ID Na...