DSXchange

Then its better to use a message handler rather than going for a join

Does your project allows you to use message handlers?

We are loading multiple Teradata tables through a single job. While loading if the job fails then all the records which were inserted in the other tables in the same run should be rolled back. .i.e either all the records should be inserted in all the tables or no records should be inserted in any of...

Its correct considering you want to pass input to the container

Hi All, I found the strange behav of this job..This is server job and i am ORAACI9 stage. this is reading a .sql file .( in .sql file there are 26 union all statemnet) Once i am passing the SQL in source stage .it is working fine for 3 union all statement. Working SQL:- SELECT Distinct CAST('Manual'...

If any one has some time..can you help me on his issue ..

Hi All, I am facing this issue "Abnormal termination of stage" .I searched this site for fault ype 11. My job is simple sever job. Source --> oracle --->Trans-->seq file. After resetting the job --> From previous run DataStage Job 1458 Phantom 3229 Abnormal termination of DataStage. Fault ...

Finally resolved it by removing the extra entries of hostnames from the second server's /etc/hosts.

Do I need to make entries in any other file to get this stuff done??

Tried it by removing kasitmisdb1, but getting the same result wihtout any luck

My default.apt config file looks like this : - { node "node1" { fastname "kasitmisdb1" pools "" resource disk "/opt/IBM/InformationServer/Server/Datasets" {pools ""} resource scratchdisk "/opt/IBM/InformationServer/Server/Scratch" {pools &q...

I fail to understand why it is having problem in connecting to the same server.

This is the entry in my /etc/hosts file : -

127.0.0.1 kasitmisdb1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
172.21.13.53 kasitmisdb1
172.21.13.254 kasitmisdb3

Hi Ray,

It is for Parallel edition not server, that wasa mistake from my end to put the post into Server.

Also my premium membership has lapsed, so could not read your reply.

Hi all, The server where my Datastage is installed has the hostname : kasitmisdb1, I have db2 installed in another server kasitmisdb3, so I have created the following config to enable remote connectivity through Enterprise edition. My config file has been designed as : - { node "node1" { f...