DSXchange

Ray thanks for the input. But even though i am able to see the multiple records for the same key when i click on view data, I am getting only unique records when i run the job. I am using Oracle Connector Stage. could you please guide me as how to set up the settings in the reference side so that mu...

Hi Guys, My Source records are unique records. But my reference records contain multiple records for the same key. Now, i want output with multiple records. Source record AA 12B 2 BB 23Y 3 Reference recrods AA 12B U- AA 12B Y- BB 23Y I+ BB 23Y O- Output required AA 12B U- 2 AA 12B Y- 2 BB 23Y I+ 3 B...

Hi Guys, I am trying to convert a server job to a parallel job. In the server job, a lookup is made with a dummy column against a job variable. The output of the lookup is that it will add one column with the same value to all the rows. Could you somebody tell me as how to achieve this in parallel.....

I feel the error is coming from StringToDate function.. Just to confirm this, can you remove the if,,, then ..else and replace it with only "StringtoDate(lnk_tr.eff_dt,"%yyyy-%mm-%dd")" and run the job.
If the error exists, then you need to look into your input columns.

Ray, i was using ExecSh option only. I modified the ExecSh routine to obtain the jobname and attach it to the command.

The issue is fixed now.

I am getting the below error SH: -c: line 0: syntax error near unexpected token `(' SH: -c: line 0: `sh -x /appl/data/VSTAR/na/scripts/test.sh -f DSGetJobInfo(DSJ.ME, DSJ_JOBNAME)' Just to check if the script is working fine, i ran it with the actual jobname itself. Executed command: sh -x /appl/dat...

Hi Guys, I am calling a shell script using the After-Job subroutine from the job properties. I need to pass the current job name for this script as a Parameter. The shell script is able to take the parameter if i run it individually. This is the code i tried. sh -x test.sh -f DSGetJobInfo(DSJ.ME, DS...

Hi Guys,

There is a server routine. Is it possible to call it in a Transformer stage in a Parallel job or i need to write parallel routine for it.

Cheers!!!!

hi priyadarshikunal, I am new to the routines. so could you help me out or point me to the right direction..
Cheers!!!

The After Job-Subroutine which is present in the Job Properites. I am calling the script using the ExecSH option in the After-Job Subroutine

Hi Guys,

I have shell script which is currently returning return code of 3.

I am calling this script from my datastage job as a After-Job Subroutine. I expect the job to fail but the job is Finished(with Warning) status.

Can somebody help me as what i am doing wrong.

Cheers!!!!!

Even in the Flat file, i am getting the value truncated.

I have given length as 22 and scale as 10 (same as Database)

Please let me know if i am missing out something. Is there any environmental variables which may restrict the decimal values?

Hi Guys, I am receiving data in Flat file. I am reading it as a Varchar and loading it to Oracle Table (Double datatype). It is loading properly (1344.324). In an another job, when i am reading it using Oracle Connector stage (Double Datatype), i am able to see the data is coming properly as 1344.32...

Hi Guys, My lookup table has 15 columns. My source table also have those 15 columns. I need to do the lookup only when the column is having value instead of Null Values. For an example: Lookup table: 1 2 3 4 5 6 7 8 9 10 Key A B NULL NULL NULL NULL NULL NULL NULL NULL 1 A B NULL Y NULL NULL NULL NUL...

The data was not getting inserted properly.

For an example, if data was 8.56, it was getting inserted as 0000000.

Not sure why, but with float, we were somewhat getting (8.5600001).

But now with double, i am getting what i want (8.56)