DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 3724 matches
Author Message
 Topic: IGC query does not constrain for Stage Column query
eostic

Replies: 1
Views: 57

PostForum: MetaData and IBM MetaData Workbench   Posted: Mon Dec 11, 2017 3:22 pm   Subject: IGC query does not constrain for Stage Column query
There is a lot going on here, Lamont.....Conditions should work, but check which path your assets are in....and check begins_with as well as contains....and start initially without going as deep as ou ...
 Topic: xml
eostic

Replies: 3
Views: 98

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 06, 2017 6:25 am   Subject: xml
You have several options. As Ray notes, the Hierarchical Stage is one possibility. This requires that you have an xsd. That xsd (schema file) will describe the "lists" that you have that generate t ...
 Topic: XML Output - Repetitive Tags
eostic

Replies: 2
Views: 115

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Dec 04, 2017 1:02 pm   Subject: XML Output - Repetitive Tags
Welcome on board! For each output link, you decide which repeating node dictates the number of rows produced. When you have parallel repeating nodes (in this example, quick glance shows taxes and c ...
 Topic: How to remove the empty tags in Hierarchical Stage
eostic

Replies: 5
Views: 195

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 04, 2017 10:09 am   Subject: How to remove the empty tags in Hierarchical Stage
Also, while its hard to determine your problem by just reading your symptom, be sure you have your Composer step settings established correctly, and that you are passing in true "null values" for any ...
 Topic: Difference between ETL(DataStage) and ESB(Mulesoft)
eostic

Replies: 1
Views: 77

PostForum: General   Posted: Mon Dec 04, 2017 5:17 am   Subject: Difference between ETL(DataStage) and ESB(Mulesoft)
This discussion is not one that I've heard too often anymore...it was a bigger issue at the height of the "service oriented archtecture" days, with comparisons of ETL tooling with ESB or "EAI" (enterp ...
Resolved
 Topic: Loop Through Columns to change type and length
eostic

Replies: 12
Views: 339

PostForum: General   Posted: Wed Nov 29, 2017 1:44 pm   Subject: Loop Through Columns to change type and length
Still...what you did is VERY cool, and you will probably find lots of future things where your research into .dsx and .dsx/xml will be a huge benefit! bravo!

Ernie
 Topic: DataStage with R functions
eostic

Replies: 5
Views: 356

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 27, 2017 6:14 am   Subject: DataStage with R functions
As Ray and Craig note, the "why" is important here.....

Technically speaking, if you know how to invoke R from Java, then it should be very straightforward. Exactly "why" you would do it is anoth ...
 Topic: XML PARSER ERROR
eostic

Replies: 3
Views: 201

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 22, 2017 5:24 pm   Subject: XML PARSER ERROR
Never seen that, but are you sure it is random? It may be something to do with the particular input docs that fail....are the incoming docs all valid?

Ernie

.....also....this probably should be ...
 Topic: Webservice call from datastage
eostic

Replies: 4
Views: 305

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 20, 2017 10:48 am   Subject: Webservice call from datastage
It's the same as for XML, but the nice thing is, you don't need any kind of schema. Just get a sample json document and "import it" via the Library Manager. Then you will feed in your normal data ( ...
 Topic: Webservice call from datastage
eostic

Replies: 4
Views: 305

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 15, 2017 1:11 pm   Subject: Webservice call from datastage
You will need to learn how to use the Hierarchical Stage, which was updated around the 11.3 time frame to support REST calls using JSON and XML payloads.

Short of that, if you are on an older relea ...
 Topic: Unstructured Stage - Array index out of range
eostic

Replies: 6
Views: 493

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Nov 04, 2017 9:05 am   Subject: Unstructured Stage - Array index out of range
Is the error at the cluent? During edit and design? Or run time?

If at the client, have you tried other workstations? Do you habe flash installed?

If at the server, not sute what to sugge ...
 Topic: Loading Excel into Hortonworks
eostic

Replies: 1
Views: 181

PostForum: General   Posted: Thu Nov 02, 2017 2:54 pm   Subject: Loading Excel into Hortonworks
Break down the problem into two parts. (1). Read an excel file with DataStage. This is done using the Unstructured Stage. Get that working sending the data to something simple, like a local Sequen ...
Resolved
 Topic: XML Stage - Reject Link Error
eostic

Replies: 3
Views: 254

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 31, 2017 5:59 am   Subject: XML Stage - Reject Link Error
That is such an old release...although I can't remember anything in particular, it is possible that this functionality has been been patched and updated on several occasions.

Still.....are you appr ...
Resolved
 Topic: XML Stage - Reject Link Error
eostic

Replies: 3
Views: 254

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 30, 2017 1:53 pm   Subject: XML Stage - Reject Link Error
What release are you on and what Stage are you using? Are you using the XML Stage, with the Assembly editor, as it was defined prior to 11.3? ...or the Hierarchical Stage as it is now called?

Ass ...
 Topic: Loading a full file into a field?
eostic

Replies: 10
Views: 670

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 30, 2017 5:21 am   Subject: Loading a full file into a field?
Or use a Server Job. The Folder Stage will easily pull the entire contents into a single column "as is". For files of a few hundred meg or less, it works perfect every time.

Ernie
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours