Search found 4 matches
- Wed Oct 24, 2012 11:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Process meta data not available
- Replies: 4
- Views: 2110
Please revalidate your odbc name in odbc.ini file.
Please revalidate your odbc name in odbc.ini file. Seems odbc is referign to some other data base.
- Mon Feb 23, 2009 6:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertial & horizontal pivoting with variable number of co
- Replies: 6
- Views: 2062
We need to develp a job so that we can create two different type of reports in xl file. For one key will be Market,Product ,Period and values will be fact and for one key will be Market,Product and fact and value will be a period. But we have variable number of columns for period and fact . Means da...
- Fri Feb 20, 2009 6:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertial & horizontal pivoting with variable number of co
- Replies: 6
- Views: 2062
- Fri Feb 20, 2009 3:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: vertial & horizontal pivoting with variable number of co
- Replies: 6
- Views: 2062
vertial & horizontal pivoting with variable number of co
Need help to do vertical and horizontal pivoting at same time and problem is that FACT columns may vary every time. Input file - MRKT|PROD|PRD|FACT1|FACT2|FACT3|FACT4 M1|P1|PR1|F11|F12|F13|F14 M1|P1|PR2|F21|F22|F23|F24 M1|P1|PR3|F31|F32|F33|F34 M2|P2|PR1|F41|F42|F43|F44 M2|P2|PR2|F51|F53|F54|F55 M2|...