Search found 10 matches

by rajeshkadiri
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

How to merge 5 rows into single row?

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
by rajeshkadiri
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

in one interview i faced this
by rajeshkadiri
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
by rajeshkadiri
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)
by rajeshkadiri
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