Search found 34 matches
- Thu Feb 05, 2015 2:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Netezza Stage Logging
- Replies: 1
- Views: 1433
- Thu Feb 05, 2015 2:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML File Transformations
- Replies: 10
- Views: 6229
I read the contents in the link and made some progress but its just not working and I am not sure where it is going wrong. To summarize, The XSD structure is below SO_PRODUCT (Parent P1) ---->SO_PRODUCT_ATTRIBUTE (child C1) ---->PRODUCT_ASSOCIATION (child C2) --------->PRODUCT_ASSOCIATION_ATTRIBUTE ...
- Wed Feb 04, 2015 12:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML File Transformations
- Replies: 10
- Views: 6229
- Wed Feb 04, 2015 12:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML File Transformations
- Replies: 10
- Views: 6229
- Wed Feb 04, 2015 9:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML File Transformations
- Replies: 10
- Views: 6229
Hello Ernie, Thank you very much for the details. The XML file in question is of 1 GB size. Hence, I am using the HierarchicalData Stage (formerly XML Stage). I have already imported the XSD as XML Table Definition like Ray suggested. Now what should I use in the assembly palette to read the data? A...
- Tue Feb 03, 2015 3:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML File Transformations
- Replies: 10
- Views: 6229
- Tue Feb 03, 2015 3:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML File Transformations
- Replies: 10
- Views: 6229
XML File Transformations
Hi, Being not very familiar with XML files, I am struggling a bit to achieve the following objective. It will be very helpful if someone can please direct me to right approach or design. Objective : Read a XML file, apply some transformations to its data (e.g. switch cases, change some values, etc) ...
- Thu Dec 18, 2014 10:00 am
- Forum: General
- Topic: Get record count as a User Variable
- Replies: 7
- Views: 3652
- Fri Dec 05, 2014 12:05 pm
- Forum: General
- Topic: DS User credential on Windows
- Replies: 3
- Views: 2283
- Fri Dec 05, 2014 10:17 am
- Forum: General
- Topic: DS User credential on Windows
- Replies: 3
- Views: 2283
DS User credential on Windows
When we run a DS job on Windows via DS Scheduler, what user ID does it use? Is it the user ID by which it was compiled last?
Say my DS job, is running on a Windows VM A and want to write a file to another VM B or to a shared drive, how do I make sure that it has appropriate permission to do so?
Say my DS job, is running on a Windows VM A and want to write a file to another VM B or to a shared drive, how do I make sure that it has appropriate permission to do so?
- Mon Nov 17, 2014 10:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Round to nearest tenth
- Replies: 3
- Views: 2689
Round to nearest tenth
Hi,
I searched the forum but couldn't get any answer. Does anyone know how to round a number to nearest equal to higher tenth.
e.g.
12 --> 20
15 --> 20
1.4 --> 10
Thanks!
I searched the forum but couldn't get any answer. Does anyone know how to round a number to nearest equal to higher tenth.
e.g.
12 --> 20
15 --> 20
1.4 --> 10
Thanks!
- Sat Oct 18, 2014 2:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Capture Record Insert Date and Record Update Date in SCD Sta
- Replies: 2
- Views: 2009
- Sat Oct 18, 2014 1:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Capture Record Insert Date and Record Update Date in SCD Sta
- Replies: 2
- Views: 2009
Capture Record Insert Date and Record Update Date in SCD Sta
Hi, I am trying to load a Dimension table which has a mixture of Type 1 and Type 2 columns in it. The data population is working fine as expected when I use the SCD stage. But I am wondering if there is a way to populate Record_Insert_Date and Record_Update_Date in this table based on if a record is...
- Thu Oct 16, 2014 1:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Netezza userdefined update query issue
- Replies: 6
- Views: 15763
- Wed Oct 15, 2014 7:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate Key using a state file or Database
- Replies: 7
- Views: 8308
Thank you, Ray. I will use the state file in the jobs are see how it goes. BTW, what is your opinion about using the inbuilt DB sequence? The only options are DB2 and Oracle. Since we have DB2 for XMETA repository, I can ask for a separate database in it for generating sequence. Will it provide any ...