DSXchange

Hi REF(TABLE b) | | SRC(TABLE a) ----- Join Stage(Left Join) --- Transformer ----- Target In the transformer --- StageVariable1 --- if a.valid_frm_date >= b.valid_frm_date AND a.valid_frm_date < b.valid_frm_date then @True else @False ---- StageVarialbe 2 -- Similarly for the b.valid_frm_date(same c...

hi

I would suggest you to write all the required columns in a temp table and then use that temp table data to get your required search

OR

use the looping mechanism , read the content of file one by one and then view the records either at one go or read all the data .

Hi

Could not view your image.

Can you put down as the text if possible

Regards
Naveen

hi, Solution 1 --------------- you can change in the oracle by setting the date format as you wanted by changing the meta data tables. Solution 2 ----------- Keep the target column as a varchar, use the Iconv and Oconv functionality in the server job to read it to the format as you wanted in the src...

Hi,


SeqFile ---- Aggreator ---- TargetFile

Group by on the first column and then in the aggreator use the count function to get the number of records.

That will resolve your issue

Regards
Naveen

Hi

you need to check on the pre-requisite of the installation of DS11.3 in the IBM site.

If I remember correctly some version of DS would only work with 32 bit Oracle Installation.Check whether the installation you did was 32bit or 64bit DS.

Regards
Naveen

Hi

It all depends on the application logic that you use within the datastage jobs.

Regards
Naveeb

Hi ,

Did you check after setting the sequence to "reset if required and then run" enabled.

Even after that the problem persist let me know.


Regards
Naveen

Hi

Create a parameter set with all the values you wanted with the respective value files to it.

Add the parameter set to the sequence.Pass those to the multiple instance jobs in a sequence. ( you dont need to create any separate sequence)

Regards
Naveen

Hi, Keep as much instance as you wanted to run in between the start loop and the end loop ...use a static (harcoded) invocation id and then run the sequence Example : if you wanted 8 parallel jobs to run SL(StartLoop)------{8 instance of the same job with hardcoded invocation id} .... EndLoop When y...

Use the stage variable read it with soundex and compare it..

Not tested it though , it should work. Logically

Regards
Naveen

hi ray,

I have created lots of server jobs.

However in the DS11.3 version , it seems like they purchased license only for the data quality stage.

Regards
Naveen

Thanks for the reply !!!

In the left panel after clicking the jobs ..I could see only parallel and sequence, I could not see the server job .

Hi All,

We have installed client version of Datastage Version 11.3 in windows platform.However I could not see the server jobs in the palette.

Do we have to get a separate license for the server edition of jobs.

Many Thanks

Regards
Naveen

you can write the content to the file with some delimiter and then read the file with execute command activity and pass it on to the next job. Example: if you have appended the , (comma) delimter your run-date would be like 27-OCT-2015, Read this file in execute command activity , you can give the c...