DSXchange

hi I seem to encoutner a curious situation when trying to update a table (key, code, desc). My intent is to update if the code exist else insert. The table is first extracted out with the key and code as lookup. Transformation logic as follows Input file (code, desc) has 2 rows of the same code. The...

hi
I thought that the variable would be incremented each time the process is repeated like @OUTROWNUM ?

If not, then I could not use the @OUTROWNUM as I wanted a serial increment ie the next serial no.

Thank you
Regards

I have found that : PWD=/u01/ascential/DataStage/DSEngine HOME=/u01/ascential Tilde test: ~dsadm: No such file or directory What the user wanted is to avoid hardcoding in the job paramters and the path required is /u01/ascential/DataStage/Projects/Data/dsdvstud/ so the more appropriate would be the ...

hi
Are you saying that I need to include the userid dsadm which is the userid I am using anyway to run the job ?

I tried to put in the userid as well :

: DSD.SEQOpen Failed to open DimCtrytest.csv in directory ~dsadm/DataStage/Projects/Data/dsdvstud
STATUS = -1.

Regards
SLL

hi I am trying to use ETL to insert and update an existing data warehouse dimension table with surrogate keys. Data would be extracted from the existing table to a csv file where amendments would be made and this would be the input to the job. What I have done is retrieve the maximum surrogate key i...

hi Craig This is one of the parameters of a DataStage job where I would prompt the user for Userid/password/path/ I have tested by placing the "~" in the job parameter but the job failed validataion : the home directory concerned is /u01/ascential/ Failed to open DimRace.csv in directory ~...

Can I use the Unix home directory ('~') instead of hardcoding the specific directory in the job parameter ?

If yes, how could this be done ?

Thank you
SLL