DSXchange

Hi,

This is resolved.

Many thanks

Pragb

Hello All, I am having issue in sending mail notification through datastage. the design of my sequence is as follows execute command stage-----User variables_Activity---Notification activity In execute command stage I am trying to read the param file through cat command,the file consists of few emai...

Hello All, I am using Netezza enterprise stage for the final load,but I am facing partial load issue in the enterprise stage.I have tried for both ET load and Nzload option,but data gets loaded partially whenever the job aborts. Is there option by which I can restrict this? Please help. Many Thanks,...

Hello All, In one of my job I am using Netezza enterprise stage as target and I am getting the error mentioned below. Exporting nullable field without null handling properties Now I know this error may come for sequential file,and i know how to solve that,but I never expect this in Database level. T...

Hi All, I am having an issue in a parallel job,The job design is as follows. Table--Lookup---Target. My reference for lookup is Dataset. Now I can view the data in the dataset,and I am having r-w-x permission for the same. But when i am running the job I am getting the following error. Data set init...

Thanks Chullet,
I agree,but my concern in that case is if I have huge millions of data and if I run on a single node,that may cause performance issue,otherwise I am ok with running on single node

Hi, Many thanks for the reply. When I am running in single node I am getting the desired output,now my question is inside the transformer in the advanced tab in the node map constraint if I giving node 1 or node 2(when it is running with 2 nodes) still its generating values like 1,3,5,7,..... As I d...

Hi,
Thanks for the reply.
My only concern is if I am incrementing it by 1 key values it should give me output like 1,2,3,4,.......... but it is giving 1,3,5,7,.........how this is possible?

Hi, I am trying to generate surrogate key from transformer stage in my job. The job structure is as follows: Database----Transformer------Datasets. Now I am generating surrogate key in a stage Variable and passing it to all 4 datasets as a key.The job is running with 2 nodes. I am using a sk file wh...

Can you use change capture stage for this because this will also give you the changes you are looking for...