DSXchange

Thanks Craig. And I have modified the original post.

Dear All - Its a general question. We are developing a Dataware house environment by using Data stage-Linux-Netezza. Most of the times our source would be "views" and without transformations the data would be mapped into Target Tables. There are few transformations, but we are handling in ...

This question is w.r.to Autosys & Shell Script.

Script has to copy around 50 tables from one DB to other DB.

Autosys JOB completes less than 60 seconds hence the script also aborts before it copy all the 50 tables to other DB.

sometimes it copies 5 to 10 tables only.

Dear Team - We are using Datastage to load Netezza Tables. After the load completes using a UNIX Shell script to copy certain tables data from One database to another Database. And we plan to schedule a autosys JOB to invoke the Shell script but whenever we test the Autosys JOB it completes less tha...

Thanks Ray. I noticed that we are using Netezza V7.X and Datastage V8.7 but the Netezza Connector has the variant 4.5 If I try to install the fix pack for the latest Netezza Connector Stage, would it help ?. However, I shall check with my DBA to determine whether its a page-level or Record-Level dea...

Dear Team - Designed a Parallel Job to invoke the Netezza Sequence by using "Netezza Connector" and this Parallel JOB has been executed with multiple instances but encountered with the following error. ; [SQLCODE=HY000][Native=46] ERROR: Deadlock detected. Resubmit your request. I hope tha...

Hello All - I am desgining a parallel JOB and using a Column Generator in order to generate a Unique number but encountered an error in V8.5 during compilation. Error : Stage 'CG_Unique_Number' requires a minimum of '1' non-reference inpu(s). But as per the IBM Knowledge Center input link is optiona...

Thanks for the suggestion Ray.

Hello All - I have designed the Sequence JOB with a Start Loop activity with List Loop items (Item1,Item2,Item3) with Comma Delimiter and triggers the JOB Activity successfully. But when I check in the JOB Message Log , the Parallel JOB has been invoked thrice with but No where the "List items&...

Which one is Faster : Normal Lookup or Sparse Lookup?

can you please tell which lookup is faster. My understanding is Normal lookup would be faster since there is no hit with DB.

Could you please explain the difference between Join Stage and Merge Stage.. I could understand that both the stages work based on the Key Column and they take multiple input links. But what is the exact difference between each of them. I have searched in the forum and found a similar post but it do...

Can anyone please explain Why Funnel and Why not Merge stage to combine several files?

Is it possible to use IF Statements and Functions in Constraints (Transformer Stage) ? or we need to incorporate such functionality with the help of Derivation/ Stage Variables?

Is it possible to open any Datastage Parallel JOB in View?.