Yesvijayrc wrote:Is this a Parallel job Stage ??
Search found 127 matches
- Fri Apr 14, 2006 5:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Splitting One Record to Many
- Replies: 10
- Views: 5468
- Thu Apr 13, 2006 8:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Splitting One Record to Many
- Replies: 10
- Views: 5468
- Wed Apr 05, 2006 6:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting Datatype From Hashed File
- Replies: 11
- Views: 5978
- Wed Apr 05, 2006 2:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to create sequence number per ID?
- Replies: 4
- Views: 2969
- Tue Apr 04, 2006 11:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 15
- Views: 7895
Hi, Sorry, there was an error in writing the stage variable names Here is the right way, StageVar=DSLink3.No StageVar2=StageVar<> StageVar1 StageVar1=StageVar StageVar5=DSLink3.Type:',':DSLink3.Name1:',': DSLink3.Name2 StageVar4=IF StageVar2=1 then DSLink3.No:',': StageVar5 else Trim(StageVar4):',':...
- Sun Apr 02, 2006 12:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Insert and update a table
- Replies: 1
- Views: 1848
- Tue Mar 28, 2006 3:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Searching a string in a set of strings
- Replies: 5
- Views: 3309
- Sun Mar 19, 2006 11:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: add/minus months function
- Replies: 11
- Views: 6142
- Thu Mar 16, 2006 12:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 28
- Views: 15774
Hi Smita, Job Design: Input----->Transformer---->Remove Duplicate----->Output Declare stage variables as follows: StageVar =DSLink3.No StageVar2 =StageVar<> StageVar1 StageVar1 =StageVar StageVar5 =DSLink3.Type:',':DSLink3.Name1:',': DSLink3.Name2 StageVar4 =IF StageVar2=1 then DSLink3.No:',': Stage...
- Wed Mar 15, 2006 12:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertical pivot
- Replies: 28
- Views: 15774
- Wed Mar 15, 2006 3:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup(looping in the ref table)
- Replies: 9
- Views: 4126
- Tue Mar 14, 2006 1:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup in a comma delimited file
- Replies: 6
- Views: 3155
Hi narshimha, If I understand your requirement correctly then You want to look up these numbers against a database table column and if any of these numbers are present in the column then reject the row. As suggested, you can pivot the data in the sequential file to get it in this format 123 432 623 ...
- Tue Mar 14, 2006 12:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: intermediate result set required from a recordset
- Replies: 19
- Views: 9188
- Mon Mar 13, 2006 6:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: intermediate result set required from a recordset
- Replies: 19
- Views: 9188
My requirement is for my input record 'a' look for the value in reference data if it finds the key value , then it should check the col2 value=4 or not. If the col2 value = 4 then take the value from the col3 which is 'b'.Then need to check the remang records in the refrence data for the 'b'.Here, ...
- Mon Mar 13, 2006 1:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: intermediate result set required from a recordset
- Replies: 19
- Views: 9188