Search found 6 matches
- Mon Feb 14, 2005 10:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inermediate link in join stage
- Replies: 6
- Views: 8130
Re: Inermediate link in join stage
Hi I have used 14 files to join using intermediate Links and it works fine. I too used a left outer join and derived not only the key columns but other columns from each of the input files as well. However, my left most file is the master file that contains two key columns and all other files contai...
- Wed Dec 15, 2004 9:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel Extender - User Defined SQL in Parallel Job
- Replies: 2
- Views: 2348
- Tue Dec 14, 2004 1:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to include Header row in sequential file
- Replies: 5
- Views: 2581
- Thu Nov 04, 2004 11:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Merging rows into a string
- Replies: 3
- Views: 2452
Re: Merging rows into a string
Vigneshra, Could you please explain how to know that job has reached the last row of the input file and how to pass only the last appended row? I had faced the similar problem, and I solved it creating a new column appending each row values using a stage variable as Vigneshra mentioned. This gives m...
- Mon Oct 18, 2004 12:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Cascading Joins
- Replies: 4
- Views: 2876
Re: Cascading Joins
Hi , What are you not getting correctly, the required columns or required rows ? I have used cascading joins quite a few. No problem faced till now. What kind of join are you using ? I normally use a transformer after each join and use a sequential file to validate my output. And if my output is cor...
- Tue Aug 31, 2004 2:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multi valued Column in Hash File
- Replies: 20
- Views: 15728
Multi valued Column in Hash File
Hi, Can anyone suggest me how to create a multi-valued colmn in a hash file ? Column should display all the values separated by comma for a particular Key. for example : input file with three columns c1,c2 & c3 c1-- c2 -- c3 NE-- 20-- 1 EX-- 30 -- 2 NE-- 40-- 3 EX-- 45-- 4 EX-- 50-- 5 And Hash f...