For join to work, the sort order of records should match in both input links.
Regards,
Senthil
Search found 79 matches
- Fri Aug 24, 2012 12:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: In line sort before join
- Replies: 7
- Views: 4014
- Fri Aug 24, 2012 12:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: In line sort before join
- Replies: 7
- Views: 4014
- Fri Aug 24, 2012 10:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partitioning for Aggregator
- Replies: 5
- Views: 2949
Re: Partitioning for Aggregator
Hi - Thanks for your comments. Ray/ArndW - Is it mandatory to pick only the 'first' key in sort as partition key? Will there be any issues if the data is partitioned on the fourth or fifth key? The reason I am asking this is, I am dealing with huge input datasets (>500million records) that is partit...
- Thu Aug 23, 2012 1:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partitioning for Aggregator
- Replies: 5
- Views: 2949
Partitioning for Aggregator
Hi, When using the aggregator in sort option the input record must be sorted using ALL the aggregate key columns, but, is it mandatory to partition it based on ALL the key columns (as documentation specifies) - isn't it enough if it is partitioned based on just one of the Key column? Thanks and Rega...
- Wed Aug 15, 2012 1:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error using Resource estimation in DS8.5
- Replies: 0
- Views: 1469
Error using Resource estimation in DS8.5
Hi, I am trying to use the resource estimation feature in Datastage8.5. I have a job that runs successfully and wanted to estimate its resource usage. So when I click File-> Estimate Resource for that job in designer, a new windows opens asking me to execute the job. When I run the job, the abends w...
- Thu Feb 10, 2011 4:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LOOKUP HELP
- Replies: 14
- Views: 6978
- Mon Feb 07, 2011 12:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading nulls and spaces into db2 table from file
- Replies: 4
- Views: 4018
The datatype of two columns are char(1). If use @ or any special character .Then i need to change into space in final job which will load into target table. If you are planning to load a null value as null into the target table, you can specify @ (or any other character) when exporting the null val...
- Sun Feb 06, 2011 2:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How do I fix performance bottleneck at Sort stage?
- Replies: 12
- Views: 7572
- Sun Feb 06, 2011 10:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading nulls and spaces into db2 table from file
- Replies: 4
- Views: 4018
- Sun Feb 06, 2011 3:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting zero records from the aggregator
- Replies: 6
- Views: 3879
- Sun Feb 06, 2011 3:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FATAL Error in transformer
- Replies: 8
- Views: 5100
- Sun Feb 06, 2011 3:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Connecting to DB2 using Datastage
- Replies: 2
- Views: 2787
- Sun Feb 06, 2011 3:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How do I fix performance bottleneck at Sort stage?
- Replies: 12
- Views: 7572
- Fri Feb 04, 2011 2:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LOOKUP HELP
- Replies: 14
- Views: 6978
- Fri Feb 04, 2011 2:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Some partition doubts
- Replies: 6
- Views: 5899
2. Selecting 'same' partition in source/output link will try to use the same partition in the source dataset created by a prior job - avoids repartitioning of data. Though 'same' can be used wtih source database stages, we need to be careful when data is read in parallel from a partitioned DB2 (and ...