Search found 48 matches

by dxp
Tue Oct 04, 2005 12:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: joining key columns
Replies: 28
Views: 13437

joining key columns

Hi when i am joining 3 or 4 tables with different key columns, in join stage only one key which is common for 2 tables is displaying. remaining keys which r common for other tables are not showing in key column list. do i need to select sort on each key column with hash partitioning? anyway i am exp...
by dxp
Mon Oct 03, 2005 11:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: repositioning columns in PX.
Replies: 6
Views: 2065

repositioning columns in PX.

Hi,

how to reposition columns in metadata tab, in PX stages.
i found same question for Server jobs in this forum.
by dxp
Mon Oct 03, 2005 12:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Max Value in date column
Replies: 10
Views: 6702

hi i got a different solution for this problem. using modify stage i converted date to----------> days_since_from_date(date), which is of date format-----to----->int32.----------->then in Aggregator..max(date in int32 format)------------>in modify stage...int32 to date...date_from_days_since(date in...