DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 3749 matches
Author Message
 Topic: ETL Modeling suggestions
eostic

Replies: 6
Views: 99

PostForum: General   Posted: Mon May 21, 2018 11:49 am   Subject: ETL Modeling suggestions
The Job generation piece of FastTrack can be challenging to reconcile and isn't used much, but one nice part about FastTrack is that it can be used to see the lineage, before you have coded anything i ...
 Topic: XML Warnings
eostic

Replies: 1
Views: 62

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 16, 2018 1:18 pm   Subject: XML Warnings
It's not clear to me when it exactly is happening. The xmlInput Stage normally does not care if an element or attribute doesn't appear in the incoming document. It simply returns nulls, or in the c ...
Resolved
 Topic: Netezza SQL Extensions XML functions oddity
eostic

Replies: 7
Views: 158

PostForum: General   Posted: Tue May 08, 2018 6:30 pm   Subject: Netezza SQL Extensions XML functions oddity
It is very likely that the xml serialize of netezza is doing it. .....probably properly and by design. Any decent xml parser/serializerhas to do this because stray odd characters in xml content th ...
 Topic: Recursive XML
eostic

Replies: 1
Views: 216

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Apr 27, 2018 11:11 am   Subject: Recursive XML
Most times, for situations like this, I prefer to use the xmlInput Stage. It more easily handles incomplete paths.

I think you said you only need the first level, but imagine if you wanted the f ...
 Topic: How to get JSON file from blob storage using DataStage 11.5
eostic

Replies: 4
Views: 239

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 26, 2018 4:00 am   Subject: How to get JSON file from blob storage using DataStage 11.5
Hi.

"blob storage" can mean a lot of things. Where exactly is it stored and in what medium [brand or type of database?, blob or clob datatype? Amazon S3?, something else?].

Ernie
Resolved
 Topic: Assign Asset to another Asset
eostic

Replies: 6
Views: 303

PostForum: MetaData and IBM MetaData Workbench   Posted: Wed Apr 25, 2018 3:38 am   Subject: Assign Asset to another Asset
Not much that you can do in that older release, no.
Resolved
 Topic: Assign Asset to another Asset
eostic

Replies: 6
Views: 303

PostForum: MetaData and IBM MetaData Workbench   Posted: Mon Apr 23, 2018 7:59 am   Subject: Assign Asset to another Asset
In 8.7, the tooling for the Business Glossary and the Metadata Workbench are still separate.

Asset to Asset relationships in the Metadata Workbench can be established via "Extension Mapping Docum ...
 Topic: Assistance in getting started in DataStage
eostic

Replies: 6
Views: 253

PostForum: General   Posted: Fri Apr 20, 2018 1:29 pm   Subject: Assistance in getting started in DataStage
Welcome to DataStage!

As noted above, short of taking a formal class, there is a lot of good information out there, from IBM and from the user and partner community...just a quick search of "gett ...
Resolved
 Topic: Assign Asset to another Asset
eostic

Replies: 6
Views: 303

PostForum: MetaData and IBM MetaData Workbench   Posted: Fri Apr 20, 2018 1:23 pm   Subject: Assign Asset to another Asset
If you have 11.5, you can create a custom attribute of the "relationship" type. This lets you create your own named relationships between assets of different types, not only for terms to assets.

. ...
 Topic: Run and complete a DataStage Job based on a value in a table
eostic

Replies: 12
Views: 352

PostForum: General   Posted: Thu Apr 19, 2018 4:08 am   Subject: Run and complete a DataStage Job based on a value in a table
It does seem confusing for you to need to poll for the change? You noted that this date changes once per day.... what initiates that change? A scheduled system program? A transaction? A web ser ...
 Topic: IGC lineage for Datastage
eostic

Replies: 6
Views: 330

PostForum: MetaData and IBM MetaData Workbench   Posted: Thu Apr 12, 2018 8:33 am   Subject: IGC lineage for Datastage
You migrate the final production DataStage metadata. This is a best practice, as the governance environment is nearly always independent from the production environments running Jobs and sized for ...
Resolved
 Topic: Which TLS version does ISD use?
eostic

Replies: 3
Views: 351

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Fri Mar 30, 2018 10:13 am   Subject: Which TLS version does ISD use?
Thanks for that info!! This makes sense --- in the end, what ISD is doing is deploying, on your behalf, a normal WAS enterprise application, with all its required bits (EAR, etc.). ....WAS has a w ...
 Topic: SSAS Cube data Import in IGC
eostic

Replies: 1
Views: 400

PostForum: MetaData and IBM MetaData Workbench   Posted: Fri Mar 02, 2018 9:29 am   Subject: SSAS Cube data Import in IGC
I haven't worked with any SSAS cube scenarios...not sure if there is any automated way, unless perhaps [url=https://dsrealtime.wordpress.com/2016/06/24/ibm-partners-with-creative-solutions-using-open- ...
 Topic: Expose DataStage job as web service
eostic

Replies: 6
Views: 627

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Tue Feb 20, 2018 2:17 pm   Subject: Expose DataStage job as web service
On my phone and on an airplane. Sorry! Not going to try and correct those.... ; ) ....unless of course, I type something like kson instead of json. haha.

Ernie
 Topic: Expose DataStage job as web service
eostic

Replies: 6
Views: 627

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Tue Feb 20, 2018 11:26 am   Subject: Expose DataStage job as web service
This is done directly, and very nicely, if you have licensed and installed the Information Services Director. .....search this forum....and the formal doc at the KC...there are years of good posts. ...
 

 Jump to:   



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