Thanks Ray for your response. The image of lookup stage and Range lookup rule is here.
http://i62.tinypic.com/ivgydd.png
Search found 26 matches
- Tue Feb 11, 2014 4:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Range Lookup issue while compiling the job.
- Replies: 2
- Views: 2501
- Tue Feb 11, 2014 10:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Range Lookup issue while compiling the job.
- Replies: 2
- Views: 2501
Range Lookup issue while compiling the job.
Hi, I need your expert help for an issue with range lookup. My job is simple, input stream has a date, my reference has Fiscal Year, Start date and End Date. I need to get the fiscal year if the input date falls between start and end date. I've specified the range lookup exactly as mentioned in the ...
- Thu Jun 27, 2013 12:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Wierd issue with DataStage job-Job hangs for 2nd run onwards
- Replies: 3
- Views: 1869
- Thu Jun 27, 2013 11:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Wierd issue with DataStage job-Job hangs for 2nd run onwards
- Replies: 3
- Views: 1869
Wierd issue with DataStage job-Job hangs for 2nd run onwards
I have a Datastage job which reads just 500 records pivots each record into 100 records and later joins those 50000 records with other tables to make final count 300,000. The wierd problem is when I compile the job and run it, it takes 3 minutes to complete. If I rerun the same job it hangs forever....
- Thu Feb 23, 2012 1:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: insert, delete and update
- Replies: 6
- Views: 4085
- Thu Feb 10, 2011 11:27 pm
- Forum: General
- Topic: Sequence Failing wierdly. Job is running but seq failing
- Replies: 1
- Views: 1781
Sequence Failing wierdly. Job is running but seq failing
Hi, I've a job 'TestJob_1' which extracts data from DB2 source and load it into oracle table. I've a sequence which calles this job. When I trigger the sequence, the sequence Aborts however the underlying job is successful... I tried multiple things but in vain.. Note- I've compiled the job and sequ...
- Fri Jun 04, 2010 9:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: I need Column Name to be processed along with data
- Replies: 3
- Views: 2079
Re: I need Column Name to be processed along with data
Thank you very much for such quick response...
- Fri Jun 04, 2010 12:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: I need Column Name to be processed along with data
- Replies: 3
- Views: 2079
I need Column Name to be processed along with data
i have 270 columns in a single row...i need to place a constraint on a column name ..for example.. my input data is - Benefits_Amt Salary_Amt Reimbursements_Amt ...... 100 40 10 I want to put constraints such as...if the column name contains the word 'Reimbursements' ..then process A, if column name...
- Fri Jun 04, 2010 9:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to write column headers to out put
- Replies: 12
- Views: 6021
- Wed Aug 05, 2009 7:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Modify Stage -- Warning mEssage
- Replies: 4
- Views: 5373
- Thu May 28, 2009 4:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error:sqlldr not found.
- Replies: 5
- Views: 6106
- Tue May 26, 2009 11:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to recount when the job runs again
- Replies: 5
- Views: 2973
- Mon May 25, 2009 11:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to recount when the job runs again
- Replies: 5
- Views: 2973
How to recount when the job runs again
Hello, What i am trying to do is --> 1> There is a set of input of 1000 customers. 2> I have to generate serial number - 1- 1000 against all these customers.Hence i used Column Generator stage. I define Count - Bigint and set Start numbering from 1,Increment by 1. 3>Now when i run the job first time...
- Fri Mar 13, 2009 4:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Looping fields
- Replies: 1
- Views: 1214
Looping fields
my i/p is in following format... : ID | KEY | DIV 111 | 123 | G 111 | 345 | E 111 | 456 | E 111 | 323 | E I just require some guidance for this piece of input and rest i can work around the o/p transformation rule is --> for the same ID map the E key to G key so o/p should be ID | KEY | DIV 111 | 12...
- Tue Mar 10, 2009 8:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Incrementing values in datastage going wrong
- Replies: 13
- Views: 12226