DSXchange

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

This is the error message what I get when two nested switches I try to sort join with each other: where group1main minoccurs="0" maxoccurs="unbounded" group1 minoccurs="0" maxoccurs="unbounded" subgroupmain minoccurs="0" maxoccurs="unbounded&quo...

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...

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 //////////////////////////////////////////////////////...

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...

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 ...

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 ...

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...

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...

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...

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...

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...

Hi All,

SyncProject tool solved the issue.
It is a very smart and user friendly tool.

Feel free to use it.
It is resolved.

Br,
Janos

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...

Yes. You are right. I received the SyncProject Tool. I will inform you how it works.