Search found 178 matches
- Wed Aug 17, 2016 12:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: V 11.5 Netezza TWT Issue
- Replies: 1
- Views: 2500
V 11.5 Netezza TWT Issue
Hi All, Post upgrade from v11.3 to v11.5 parallel jobs that have an ODBC Connector as either a source or a target and that writes or reads using Netezza Connector stage have started failing due to TWT issues. Log says it cannot find the intermediate table for the final insert into Netezza where Sour...
- Mon Apr 11, 2016 2:06 pm
- Forum: IBM QualityStage
- Topic: Address Verification (AVI) - Output Variables
- Replies: 11
- Views: 15653
- Tue Dec 22, 2015 10:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Character Set ISO-8859-15
- Replies: 1
- Views: 3777
Character Set ISO-8859-15
Hi All, We currently have the default Parallel Maps set to ASCL_MS1252 for our project. Now we have a need to process data that falls under the ISO-8859-15 classification as we expect to get the French Accents in the data If we change this default parallel map, at a project level, to the required ch...
- Fri Nov 06, 2015 3:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage to Dash DB & Netezza
- Replies: 0
- Views: 2394
Datastage to Dash DB & Netezza
Hi All, We are planning to build Datastage jobs that write to both Netezza and DashDB (say as DR) with same business rules So we would end up using Netezza Connector and I believe ODBC connector for DashDB (it has DB2 as the database) Has anyone connected and written to DashDB using Datastage? Looki...
- Mon Oct 12, 2015 8:22 am
- Forum: General
- Topic: Deploy Only 1 Job From a Package
- Replies: 2
- Views: 2495
Deploy Only 1 Job From a Package
Hi All, I created a package to back up all the jobs in out project, via Information Server Manager Now we want to deploy only 1 job from this package back to the same project in the same Env (to get back old job). Is it possible? I tried to deploy the package from Information Server Manager but I se...
- Fri Oct 09, 2015 8:15 am
- Forum: General
- Topic: Parameter Set Limit
- Replies: 3
- Views: 3216
- Thu Oct 08, 2015 12:13 pm
- Forum: General
- Topic: Parameter Set Limit
- Replies: 3
- Views: 3216
Parameter Set Limit
Hi All, Is there a Limit to how many Parameters we can have in a Parameter Set? If Not, is there a realistic threshold post which we should no longer add more parameters to the parameter set? We currently have 3 Parameter Sets with 1 hitting 30 Params in it Finally, on same lines is there a limit to...
- Thu May 21, 2015 2:11 pm
- Forum: General
- Topic: Sequence Job Trigger
- Replies: 5
- Views: 4973
- Thu May 14, 2015 7:49 am
- Forum: General
- Topic: Sequence Job Trigger
- Replies: 5
- Views: 4973
Sequence Job Trigger
Hi All, I have a Sequence job and I have the Exception Handler --> EMail --> Terminator stage at the end to trap all Exceptions (Failures) I have checked the 3 options in job properties: Add Checkpoints so Sequence is Restartable Log Warnings for activities that finish with status other than OK Auto...
- Fri May 01, 2015 2:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Netezza Connector- Temp Tables - Not Dropped Automatically
- Replies: 3
- Views: 5933
I created a Stored Procedure that loops for Tables/External Tables starting with NZCC_% found via the _V_Table and Dropp them as a Post Process as part of the ETL cycle. Since Netezza does not allow Cross Database DDL/DML, create this same procedure in Staging and Target (Star Schema) Database and r...
- Fri Apr 24, 2015 10:06 am
- Forum: General
- Topic: Trigger conditon after all Iterations in Loop end in Seq job
- Replies: 1
- Views: 2325
Trigger conditon after all Iterations in Loop end in Seq job
Hi All, We are using the Start and End Loop to for some specific action in the Sequence job, which starts at 1 and ends at 10 with a step of 1. We need to send an email notification when we finish all Iterations and Exit without breaking out of it.. How can this Trigger condition be captured? Thanks...
- Fri Apr 24, 2015 7:02 am
- Forum: General
- Topic: Master Sequence Job Design
- Replies: 5
- Views: 3990
Ray I believe you mean the Scheduler from the Director Client right. Yes we have that but it is a pretty basic one, what I meant was something like an Enterprise Scheduler where I can build dependencies using it between jobs, scripts and other components involved in the End to End ETL Cycle Using th...
- Thu Apr 23, 2015 1:03 pm
- Forum: General
- Topic: Master Sequence Job Design
- Replies: 5
- Views: 3990
Master Sequence Job Design
Hi All, We do not have a Scheduler and hence we are planning to design a Master Sequence job by which we will control the end-end ETL cycle, right from polling for a Trigger File to start the Cycle and then load Staging Tables followed by Ref tables followed by Dim tables followed by Fact Tables and...
- Thu Apr 23, 2015 12:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Netezza Connector- Temp Tables - Not Dropped Automatically
- Replies: 3
- Views: 5933
- Tue Apr 21, 2015 1:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Netezza Stored Procedure Return Value
- Replies: 3
- Views: 3201
For the scenario where I wanted to use a Return Code to halt the ETL cycle, I am now throwing an Exception in the Stored Procedure itself (instead of using a separate return code) and so now the SP fails conditionally..hencethe job fails and I can then halt the next processes in the Cycle using this...