Hi
how to merge 5 rows into single row?
source
eno,sales,month
101,5000,jan
102,4000,feb
103,6000,mar
104,7000,apr
105,3000,may
output
eno,jan,feb,mar,apr,may
101,5000,4000,6000,7000,3000
Search found 10 matches
- Sat Nov 15, 2008 10:18 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: How to merge 5 rows into single row?
- Replies: 1
- Views: 2856
- Thu Apr 10, 2008 12:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to integrate 2 data marts
- Replies: 7
- Views: 3343
- Thu Apr 10, 2008 12:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Prerequisite for every stage if we are doing jobs
- Replies: 4
- Views: 2196
Prerequisite for every stage if we are doing jobs
[quote][/quote]
- Thu Apr 10, 2008 12:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what is scratch stage in datastage
- Replies: 7
- Views: 2921
- Thu Apr 10, 2008 12:41 am
- Forum: General
- Topic: Hash partion is not working
- Replies: 2
- Views: 1698
Hash partion is not working
working. if i set 4 nodes, only 3 nodes take data and 1 node doesn't take data.
if i want to see the data in nodes error is coming
if i want to see the data in nodes error is coming
- Thu Apr 10, 2008 12:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what is scratch stage in datastage
- Replies: 7
- Views: 2921
what is itch stage
what is itch stage
- Thu Apr 10, 2008 12:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what is scratch stage in datastage
- Replies: 7
- Views: 2921
- Wed Apr 09, 2008 11:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: diff b/t .dsx and .xml in datastage manager
- Replies: 4
- Views: 2676
- Fri Sep 28, 2007 8:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ignoring a column in the target DB stage
- Replies: 12
- Views: 7933
i am thing
r u enter new column in transformer stage?
(3columns)input------->transformer stage(4 columns)--------->
targer(4columns)
(3columns)input------->transformer stage(4 columns)--------->
targer(4columns)
- Fri Sep 28, 2007 8:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Defalt date is inserting into Date field in Oracle database
- Replies: 2
- Views: 1380
i thing u just insert date as a default in job property
i thing u just insert date as a default in job property
or
if u using transformer stage there u must choose datatype date
------------
rajeshds
or
if u using transformer stage there u must choose datatype date
------------
rajeshds