Search found 66 matches
- Mon Jun 22, 2009 11:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read lookup file into memory using basic routine
- Replies: 15
- Views: 6287
It is working if it is direct match,but i have situation to check if the lookup file columns has ANY that means what ever the incoming value it is matched(becuase of ANY) and also i have some other conditions to match. That is the reason i am asking is there any way i can just read each line from th...
- Mon Jun 22, 2009 9:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read lookup file into memory using basic routine
- Replies: 15
- Views: 6287
- Mon Jun 22, 2009 1:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read lookup file into memory using basic routine
- Replies: 15
- Views: 6287
Code: Select all
Input Arg : InputFile,
Arg_SERVICE_GROUP_CODE,
Arg_SOURCE_SYSTEM_ID,
Arg_PLACE_OF_SERVICE_CODE
Return Value :CLAIM_TYPE_IND
- Mon Jun 22, 2009 1:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read lookup file into memory using basic routine
- Replies: 15
- Views: 6287
Code: Select all
Input Arg : InputFile,
Arg_SERVICE_GROUP_CODE,
Arg_SOURCE_SYSTEM_ID,
Arg_PLACE_OF_SERVICE_CODE
Return Value :CLAIM_TYPE_IND
- Mon Jun 22, 2009 12:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read lookup file into memory using basic routine
- Replies: 15
- Views: 6287
- Mon Jun 22, 2009 12:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read lookup file into memory using basic routine
- Replies: 15
- Views: 6287
- Mon Jun 22, 2009 12:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read lookup file into memory using basic routine
- Replies: 15
- Views: 6287
Read lookup file into memory using basic routine
Hi, I have a situation where i need read a file using sequential file stage and then do lookup using sequentil file only (lookup includes range,ANY...) Is there any way i can read the entire file in memory using basic routine and use that for each incoming record to do a lookup. Currently i am using...
- Tue May 19, 2009 11:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: split record
- Replies: 2
- Views: 1881
split record
Hi,
I have situation where i need to split a record into multiple records based on date.
InputData :
ID|BeginDate|EndDate
100|2009-01-01|2009-03-31
OutPut :
100|2009-01-01|2009-01-31
100|2009-02-01|2009-02-28
100|2009-03-01|2009-03-32
Any thoughts how to implement this un datastage
I have situation where i need to split a record into multiple records based on date.
InputData :
ID|BeginDate|EndDate
100|2009-01-01|2009-03-31
OutPut :
100|2009-01-01|2009-01-31
100|2009-02-01|2009-02-28
100|2009-03-01|2009-03-32
Any thoughts how to implement this un datastage
- Mon Nov 10, 2008 1:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding PartitionTable Option in oracle Enterprise stage
- Replies: 3
- Views: 1832
Regarding PartitionTable Option in oracle Enterprise stage
Hi, I am reading from a oracle table which not partitioned.But if i use PartitionTable option in Oracle enterprise stage to the read this unpartitioend table i see the performance improvement. Can any one pelase explain me when we need to apply partitiontable option.What is the use of this option ev...
- Fri Nov 07, 2008 12:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding Merge and Join Stage
- Replies: 2
- Views: 1921
Regarding Merge and Join Stage
Is there any performance difference between join and merge stage except merge has a reject link and join does not have.
Thanks
Thanks
- Sat Oct 25, 2008 8:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding &SAVEDLISTS&
- Replies: 1
- Views: 1850
Regarding &SAVEDLISTS&
I would like to what information will be stored in &SAVEDLISTS& folder.I saq like what ever i executed in datastage command line all the information is stored in &SAVEDLISTS& folder.If i delete those files it will affect the project. can anyone please tell me what is the importance o...
- Sat Oct 18, 2008 6:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding Copy stage
- Replies: 2
- Views: 1531
Regarding Copy stage
Hi,
What is the use of force property in copy stage.When we need choose true or false.It influence any performance.
Thanks
What is the use of force property in copy stage.When we need choose true or false.It influence any performance.
Thanks
- Sat Oct 18, 2008 3:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Get invocation IDs of a multiinstance job
- Replies: 3
- Views: 2172
- Sat Oct 18, 2008 12:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Get invocation IDs of a multiinstance job
- Replies: 3
- Views: 2172
Get invocation IDs of a multiinstance job
Hi,
Is there any way can we get how many instances of a particular job ran with out using a director.
Thanks
Is there any way can we get how many instances of a particular job ran with out using a director.
Thanks
- Fri Oct 10, 2008 1:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need Aggregation logic in transformer
- Replies: 6
- Views: 3999
Need Aggregation logic in transformer
I have areuqirement like below.
I need to find the max value by grouping on two columns.If even if i have a negative value but i need to take absolute value but in the output i need to populate originaal value.
Input data:
100,200,-5
100,200,1
100,200,-4
Output :
100,200,-5
Thanks
I need to find the max value by grouping on two columns.If even if i have a negative value but i need to take absolute value but in the output i need to populate originaal value.
Input data:
100,200,-5
100,200,1
100,200,-4
Output :
100,200,-5
Thanks