DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 110 matches
Author Message
 Topic: Netezza for loop
jackson.eyton

Replies: 1
Views: 32

PostForum: General   Posted: Wed Sep 19, 2018 3:28 pm   Subject: Netezza for loop
DataStage® Release: 11x
Job Type: Server
OS: Windows
Additional info: NETEZZA
Hey guys, I have been reading up on for loops as I am hoping to simplify one of our cleanup tasks. I started reviewing here:
CREATE OR REPLACE PROCEDURE generateTime(integer)
LANGUAGE NZPLSQ ...
Resolved
 Topic: Set Parameter Value with Data Item
jackson.eyton

Replies: 5
Views: 431

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

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

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

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

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

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

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

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

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

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

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

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

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

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.
 

 Jump to:   



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