DSXchange

Guys , Good to be back after a long time , but with one doubt offcourse . I have been trying to access all post available in this site , and accross the Internet , but I might not have been able to frame my question yet, thats why I'm ending in a dead alley everytime. I intend to run a very simple s...

I have been searching a while for some concrete explanation on the requisite of the Prefetch Row Count and Prefetch Buffer Size property of an Oracle Connector stage , but wasnt able to find any ? Can anyone please guide me on the signifcance of these two features of the stage ? As far as the IBM In...

Lets say the input has only one record for which : NAME : N1 LOCATION : L1 RCT_CODE : R1 TXN_DT : D1 BANNER_NAME : B2 POOL_NUMBER : P2 and the reference data sources have data like : REF1 : P1_NAME P1_LOC R_CODE SRC1_D1 SRC1_D2 N1 L1 R1 <Some value> <Some value> N1 L1 R1 NULL NULL N1 L1 R1 <Some val...

@priyadarshikunal : The lookup failuer options has been set to CONTINUE since start. @jwiles : To asnwer your different permutations and combinations , I would take just a few steps to walk you though my problem. As it has been mentioned earlier in my post , a mandatory column TXN_DT need to be vali...

My job's input data consists of the following six mandatory columns: NAME LOCATION RCT_CODE TXN_DT BANNER_NAME POOL_NUMBER The input data needs to be validated( exact word should have been LOOKED UP) against two reference data sources : REF1 : P1_NAME(column against which the input NAME column of th...

@chulett: We have been running the same unix script ( but in another server), and the script runs wihtout any error even if the user/password/domain is NOT PASSED to the command line. Its just this new server that the script fails , and that too for one specific user only. @ray: I DO NOT HAVE ANY ID...

Hi, It been a long time since I posted last , but its good to be back amongst the guru's of DS. I am facing an issue while trying to execute a datastage job by invoking DSJOB command via a Unix shell script and this is making me go nuts all over. What we are doing : I have created a Unix KOrn shell ...

THE ONE thing I forgot to mention in my post, If the fields on which join is performed is Nullable, and if they actually contain NULL values , will the output of the database join match the output of the Datastage JOIN stage ( using multiple join keys ) ? I often faced this problem , that if the fie...

Let's us consider that I need to implement the following database logic in Datastage . How would I go for it ? The requirement is to JOIN two data sources based on TWO KEY COLUMNS soemthing like : select A.COL1 , A.COL2 , B.COL1, B.COL2 from table1 A JOIN table2 B on A.COL3=B.COL3 and A.COL4=B.COl4 ...

I went through numerous posts and I wasnt able to find that one piece of GOLD which can bail me out of this misery. The scenario is : I am executing the "dsjob" command from our Unix prompt(using a shell script) and passing the same project name and job name to it , and the differences bei...

Now that I am able to LOAD the parameter set value file onto the parameter set thanks to the informative post by James Wiles , I got stuck somewhere else . The job runs , but throws a new kind of error now . Parameter set parameter P_SET.$DIR unset in value file p_value_ref. Parameter set parameter ...

As per job log
Unable to load value file p_value_ref for parameter set P_SET .

To answer your second question, I really dont know how to run dsjob

while attached to the actual project directory

.




Thanks
Kumarjit.

In our parallel job j_test_job in the project test_project , we are using a Parameter Set P_SET which has three user defined DS Environment variables in it: $DIR [default value is/apps/temp] $USER [default value is ADMIN] $CONNECT [default value is password] What we want is to run the same job using...

This may sound wierd,. but I came accross a requirement which I am not able to implement using the following job design Ref1 | | Oci_Src ---- Lookup ---- Tfm ----Oci_Tgt | | Ref2 Among many of the columns in the dataset from Oci_Src are the following two columns : > AIRLINE_NUMBER - This is the key ...

Appreciate your response. There are quite a few jobs which were in ABORTED state, some of them had logs created in teh Director , but suprisingly there is ONE specific job which had Aborted and NO LOG was created for it. We didnt change any of the Design settings while migrating the jobs to the new ...