DSXchange

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

Robert, is this Add-On Module Free to install or is there a cost to get it?

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

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

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

Thanks for the Insights

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

Yes this is indeed the problem. Once I Unchecked the "Log Warnings for Activities.." option and only had the other 2 checked, I started receiving the Failure Notifications as expected. On reaching out to IBM support, they came back with this same answer..so It is a BUG even in the latest v...

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

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

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

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

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

Thanks for the reply Mani,
So if we have 100's of tables, you manually created a Temporary Work Table for each of these once and then they would be Truncated and loaded everyday (daily cycle) ?

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