Search found 109 matches
- Thu Jan 23, 2014 10:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML generation using XML output stage
- Replies: 9
- Views: 5211
Ernie, I have a small doubt, I need to pass column/field name along with column value, am I right? Before Pivot stage can I use transformer to pass the column/field name by hard coding column/field name. If it is so then I got the output as you advised me in previous post. Please advise me. Thank you,
- Wed Jan 22, 2014 2:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML generation using XML output stage
- Replies: 9
- Views: 5211
Thanks Ernie, I am able to drag columns out from pivot stage. So in my case each row is getting split in to 15 rows (4 date columns so each date has day, month and year so 4*3=12 and then title, funder, amount. Total 12+3=15). Could you please advise me how to proceed further after pivot stage outpu...
- Wed Jan 22, 2014 10:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML generation using XML output stage
- Replies: 9
- Views: 5211
- Wed Jan 22, 2014 9:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML generation using XML output stage
- Replies: 9
- Views: 5211
- Tue Jan 21, 2014 12:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML generation using XML output stage
- Replies: 9
- Views: 5211
XML generation using XML output stage
Hi, I need to generate following XML format. Could anyone advise me on this? <import-record type-id="1" xmlns="http://www.simple.com/publications/api"> <native> <field name="application-date"> <date> <day>element.getStartDate().substring(3,5) </day> <month>element.getSt...
- Thu Dec 05, 2013 8:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output
- Replies: 11
- Views: 4888
- Thu Dec 05, 2013 3:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output
- Replies: 11
- Views: 4888
- Thu Dec 05, 2013 10:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output
- Replies: 11
- Views: 4888
- Thu Dec 05, 2013 10:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output
- Replies: 11
- Views: 4888
- Wed Dec 04, 2013 5:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output
- Replies: 11
- Views: 4888
XML Output
Hi, I am working on java integration and for that I need to pass XML data. I am using XML output to get XML format from oracle table data. If I am passing duplicate rows I am getting only one row (first tag is repeating). Please take a look at below output format. I need 3 rows separately. Please ad...
- Wed Dec 04, 2013 5:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to process one row at a time using Java Integration?
- Replies: 7
- Views: 3400
- Tue Dec 03, 2013 12:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to generate only odd values/numbers in surrogate key gen
- Replies: 2
- Views: 2360
How to generate only odd values/numbers in surrogate key gen
Hi,
Could anyone please suggest me how to generate only odd numbers as (1,3,5,....) surrogate keys ?
Thank you,
Could anyone please suggest me how to generate only odd numbers as (1,3,5,....) surrogate keys ?
Thank you,
- Thu Nov 28, 2013 1:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to process one row at a time using Java Integration?
- Replies: 7
- Views: 3400
- Thu Nov 28, 2013 12:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to process one row at a time using Java Integration?
- Replies: 7
- Views: 3400
- Thu Nov 28, 2013 11:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to process one row at a time using Java Integration?
- Replies: 7
- Views: 3400
How to process one row at a time using Java Integration?
Hi, I need to process one row at a time. I mean my job needs to touch 2nd row after 1st row got processed completely. I am pulling data from oracle and doing some transformations and then passing to java integration stage. So I need to process one row at a time because java integration stage writes ...