Any wise advice is welcome. Premium or regular.
I am open to use less heavy enterprise product like python to make this work.
Microsoft or IBM....
same
Search found 59 matches
- Thu May 02, 2019 10:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchical Stage:sort join issue with parent -child switch
- Replies: 9
- Views: 7354
- Thu May 02, 2019 2:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchical Stage:sort join issue with parent -child switch
- Replies: 9
- Views: 7354
- Tue Apr 30, 2019 6:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchical Stage:sort join issue with parent -child switch
- Replies: 9
- Views: 7354
My ultimate goal: flatten XML data to multiple records and load it into one staging table. Current solution loads to 24 in the same time. XML file sample: <employee> <name>Joe</name> <telephones> <telephone >11111111</telephone> <telephone >22222222</telephone> </telephones> <employee> Wished record...
- Mon Apr 29, 2019 12:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchical Stage:sort join issue with parent -child switch
- Replies: 9
- Views: 7354
I have many phenomenon of errors. Nullpointer, Invalid parent cursor, etc Question: How can I make this work? Is this a bug? I make switches of the groups and I attempt order join with them. switches: IS ICs IC IDs ID Switch -------------- scope //////////////////////////////////////////////////////...
- Sun Apr 28, 2019 4:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchical Stage:sort join issue with parent -child switch
- Replies: 9
- Views: 7354
Hierarchical Stage:sort join issue with parent -child switch
Hi, A complex XSD is given. Perhaps it was created with copy-paste way, because every node and leaf is optional and unbounded too. The xsd had no solid point. Every leaf has a wrapper node without any attributes. Their minoccur is "0" and maxoccur="unbounded" too. Every attribute...
- Mon Apr 15, 2019 4:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: List to Group in XML Stage
- Replies: 7
- Views: 7667
That is ok. What can stop Shivra to pay attention to this post a after 3 years. I have been asked in the job to do the same with more complex xsd. Well. I can not make it. I create switches where minocccurs=0. I don't know why but if one elemnt is null than the complete group is unavailable. I make ...
- Fri Apr 12, 2019 10:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: List to Group in XML Stage
- Replies: 7
- Views: 7667
Re: List to Group in XML Stage
Hi Shiva, I did ..something again. 1. Group To List everything in the begining. Why? Because I dont understand but now it doesnt give any error message. 2. switch with all relevant lists 3. Order join step: Right : which has value all the time (parent) Left : child both of them from switch What did ...
- Fri Apr 12, 2019 7:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: List to Group in XML Stage
- Replies: 7
- Views: 7667
Re: List to Group in XML Stage
Hi Shiva, The same stuff stole 5 hours of my life... Than I pissed off and I tried to made everything what possible this "Group To List" option. It gives no error finaly. Somehow I liked more when I needed to add the XPATH descriptions, than this fency stuff. This on just prepare and prepa...
- Fri Apr 12, 2019 11:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Can old XML Input Stage use new XSD Schema Library?
- Replies: 1
- Views: 12103
Can old XML Input Stage use new XSD Schema Library?
Hi, I have a DataStage 11.3 version. I use server job to consume few amount of xml data in every 5 minutes. It seems like if I give the name space description with schemaLocation="/tmp/myschema.xsd" then it doesn't find it. Is it possible to use Schema Library xsd references in the old XML...
- Mon Nov 19, 2018 1:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Teradata Multi-load fails with character error
- Replies: 15
- Views: 54170
Workaround
As some of my colleague asked more workarounds: You can create error table in teradata of any table: Syntax CREATE ERROR TABLE FOR tbl_name; What I recognized that many quick and dirty developers try to load the data in ansi mode because it gives no error. If the data is in UTF8 it is highly not rec...
- Wed Mar 20, 2013 1:44 am
- Forum: General
- Topic: How to query in XMETA Parallel jobs default values
- Replies: 1
- Views: 2260
How to query in XMETA Parallel jobs default values
Hi All, I am looking for a query which can extract the parallel jobs' parameters default value from XMETA. Basically I need to extract all parallel jobs parameter names and default values. I know it is possible to run queries via Administrator command line or via UVSH. I could do it also. I heard th...
- Mon Oct 15, 2012 11:04 am
- Forum: General
- Topic: why DS export to utf-8 became iso-8859-1
- Replies: 2
- Views: 3439
Re: why DS export to utf-8 became iso-8859-1
Almost true.... http://www-01.ibm.com/support/docview.wss?uid=swg21588645 Message: sourcefile,0: Invalid character(s) ([xF1]) found converting string (code point(s): user Jorge Ya[xF1]ez) from codepage UTF-8 to Unicode, substituting. le, the job (or project) was setup to default to UTF-8 character s...
- Sat Oct 13, 2012 5:27 am
- Forum: General
- Topic: Can not delete category from designer
- Replies: 5
- Views: 3833
- Sat Oct 13, 2012 12:05 am
- Forum: General
- Topic: why DS export to utf-8 became iso-8859-1
- Replies: 2
- Views: 3439
Re: why DS export to utf-8 became iso-8859-1
Hi All, I figured out what is the reason to get ISO-8859-1 instead of UTF-8. When I let the NLS in Project default(UTF8) then the linux command file --mime <filename> said it is in unknown format. When I set the Sequential File stage NLS to UTF8 I got ISO-8859-1. When I changed the fields property o...
- Thu Oct 11, 2012 2:24 pm
- Forum: General
- Topic: Can not delete category from designer
- Replies: 5
- Views: 3833