DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 106 matches
Author Message
 Topic: Custom Parallel Stagetype - Wrapped
jackson.eyton

Replies: 7
Views: 408

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 14, 2018 9:32 am   Subject: Custom Parallel Stagetype - Wrapped
Any luck on this?
 Topic: CDC stage in Datastage 11.7
jackson.eyton

Replies: 10
Views: 883

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jun 12, 2018 8:51 am   Subject: CDC stage in Datastage 11.7
Sorry to dig this back up but when I search for Change Data Capture stage all I get are documents referring to the Change Capture stage, which I am really hoping is different from the Change Data Capt ...
 Topic: Custom Parallel Stagetype - Wrapped
jackson.eyton

Replies: 7
Views: 408

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 11, 2018 7:59 am   Subject: Custom Parallel Stagetype - Wrapped
I really dont have any experience with BLOB data but have you tried using Run time Column Propagation (RCP) from the source to a sequential file? See what the BLOB data looks like then?
 Topic: Custom Parallel Stagetype - Wrapped
jackson.eyton

Replies: 7
Views: 408

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jun 05, 2018 10:07 am   Subject: Custom Parallel Stagetype - Wrapped
To my understanding a wrapper stage is one that passes data through to an external executable or script and reads the response from said program/script. As such your support team would still need to m ...
 Topic: Parameterized password in Stored Procedure stage
jackson.eyton

Replies: 12
Views: 428

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 25, 2018 1:49 pm   Subject: Parameterized password in Stored Procedure stage
Just wanted to say this was a great eye opener to read, not current issues with this but perhaps just avoided any in the future. Thanks everyone!
Workaround Reported
 Topic: ETL Modeling suggestions
jackson.eyton

Replies: 11
Views: 425

PostForum: General   Posted: Thu May 24, 2018 7:43 am   Subject: ETL Modeling suggestions
HAHAHA, ok I only laughed because I use n++ all the time, just not for mapping... yet... UCDI, you mentioned HTML maps of the model, is that something that your architect puts out via Data Architect?
Workaround Reported
 Topic: ETL Modeling suggestions
jackson.eyton

Replies: 11
Views: 425

PostForum: General   Posted: Wed May 23, 2018 8:15 am   Subject: ETL Modeling suggestions
Hmm I went through one of IBMs training/demo documents for FastTrack and tried to replicate one of our jobs that we already have. I could not get the lookup entered correctly as we use a joined source ...
Resolved
 Topic: Netezza SQL Extensions XML functions oddity
jackson.eyton

Replies: 7
Views: 347

PostForum: General   Posted: Wed May 23, 2018 7:40 am   Subject: Netezza SQL Extensions XML functions oddity
Ray - That certainly would work, unfortunately this is a block of code that we are needing cognos to run directly. We did get it to work using replace() in the select statement.
Workaround Reported
 Topic: ETL Modeling suggestions
jackson.eyton

Replies: 11
Views: 425

PostForum: General   Posted: Fri May 18, 2018 12:54 pm   Subject: ETL Modeling suggestions
Yea, we are doing in a combination of both methods. Our architect models a particular table from our old database into the new model. That table from the old world will populate several different fiel ...
Workaround Reported
 Topic: ETL Modeling suggestions
jackson.eyton

Replies: 11
Views: 425

PostForum: General   Posted: Fri May 18, 2018 10:42 am   Subject: ETL Modeling suggestions
DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi, I just wanted to get some pointers or opinions on what you guys use for relaying ETL instructions from the data architect. Currently we have these setup in a spreadsheet and its not the easiest th ...
Resolved
 Topic: Incompatible data type for properly set column
jackson.eyton

Replies: 2
Views: 239

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 18, 2018 7:50 am   Subject: Incompatible data type for properly set column
alright figured this out, seems odd that we've not run into this before as this is not a new thing for us but we had to cast every NULL field of non VarChar type to its intended type.
Resolved
 Topic: Incompatible data type for properly set column
jackson.eyton

Replies: 2
Views: 239

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 17, 2018 7:28 am   Subject: Incompatible data type for properly set column
DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi,
I seem to be having an issue with a source query and its column definitions. Using the netezza connector, the columns defined were all done by hand, not imported from a table definition. I had ...
Resolved
 Topic: Netezza SQL Extensions XML functions oddity
jackson.eyton

Replies: 7
Views: 347

PostForum: General   Posted: Tue May 15, 2018 6:58 am   Subject: Netezza SQL Extensions XML functions oddity
My apologies, yes, all good!
Resolved
 Topic: Netezza SQL Extensions XML functions oddity
jackson.eyton

Replies: 7
Views: 347

PostForum: General   Posted: Wed May 09, 2018 7:15 am   Subject: Netezza SQL Extensions XML functions oddity
Ahh that makes sense, unfortunately we are not using it to deal with any real XML or even be interpreted later as XML, but instead as a method of group_concat that is technically supported by IBM.

...
Resolved
 Topic: Netezza SQL Extensions XML functions oddity
jackson.eyton

Replies: 7
Views: 347

PostForum: General   Posted: Tue May 08, 2018 10:29 am   Subject: Netezza SQL Extensions XML functions oddity
DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi everyone,
When running the following query we are seeing that any instances of '&' in BRANCH_NAME are being represented as '&amp' in the output for NZ_CONCAT_STRING and anything that foll ...
 

 Jump to:   



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