DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 109 matches
Author Message
Resolved
 Topic: Set Parameter Value with Data Item
jackson.eyton

Replies: 5
Views: 182

PostForum: Cognos (IBM BI)   Posted: Fri Jul 06, 2018 7:32 am   Subject: Set Parameter Value with Data Item
I did in fact get a work around for this functioning. Basically I have a report that has a prompt to run one of a selection of report pages. The report pages use the same query but with different filt ...
Resolved
 Topic: Set Parameter Value with Data Item
jackson.eyton

Replies: 5
Views: 182

PostForum: Cognos (IBM BI)   Posted: Tue Jul 03, 2018 8:06 am   Subject: Set Parameter Value with Data Item
Mike,
I think our wires are crossed, or I am misunderstanding. I am referring to Cognos reports. In any case I think I found a way around what I was trying to do, many ways to skin the cat thankf ...
Resolved
 Topic: Set Parameter Value with Data Item
jackson.eyton

Replies: 5
Views: 182

PostForum: Cognos (IBM BI)   Posted: Mon Jul 02, 2018 2:43 pm   Subject: Set Parameter Value with Data Item
DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi, I was curious about setting a parameter value using a Data Item. I have a report that I have created a Data Item that uses a CASE WHEN condition to try and set the value of ?myParam? parameter. Th ...
 Topic: Custom Parallel Stagetype - Wrapped
jackson.eyton

Replies: 8
Views: 636

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: 1126

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: 8
Views: 636

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: 8
Views: 636

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: 569

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: 509

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: 509

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: 425

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: 509

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: 509

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: 286

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: 286

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

 Jump to:   



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