DSXchange

Hi , I have a job which needs to load into sas datasets. I found in documentation that we have SAS processing stage and also a SAS dataset stage. But I couldn't see it in my palette. We have enterprise edition here. Are the SAS components a separte pack or do we have it in enterprise edition? if we ...

Hi All, I have a job with two remove duplicates , a lookup stage and two transformers. My source and target are database stages I have to run job with around 30 million records. Length of a record is 50 Can anyone suggest how much space do I need to have? how do i calculate the disk space needed? Th...

Hi All,

Can anyone tell me the format to uncompress a oracle table
in a sql query.

thanks

Hi All, I have hash file as input to a transformer and two outputs( one for target table and one for target error table) In transformer I gave constraints as link1.rejected for the error table link1 is output to target table I am not getting the rejected row in error table but a warning which says &...

You can use

Iconv(columnname,"MCA"),"MCN") which gives data containing only alphabets and numerics, all other or removed

You can use

Iconv(Iconv(coulmnname, "MCA"),"MCN") to get only alphabetic and numerical values from the column and avoid all other.

Hi Atul, can u check if the same oracle tables are being used parallely by any other job or used in the same job. If so check if INITRANS AND FREELISTS of the tables are 1 or more(more than th no of times it is used parallely). If it is 1 and used parallely then it is the problem. Change the value

Hi Bapajju, Did you solve the problem or else try this change(change(change(coulmn name,'","','|'),',',' '),'|','","') I think this should work. It first converts "," to | and then changes the comma with in a string value to space and finally converts | back to ",&...

Try to divide the updates and inserts in the transformer itself. Use Oracle stages two one for update and one for insert if you have inserts.

In transformer write constraints saying if ename=",.." and dept=.. then go to update stage or insert stage.

I tried with the specification you gave, the results were fine. I got refernce column value when rate is null. results are
sap20.5
yrs
tmp10

I used -- refernce:rate as output column value in transformer

You can try with If len(rate)=0 then reference else reference:rate

Once I faced an error saying 'DS_JOBOBJECTS cannot be written' this is because I had no permissions to make changes in that project.

Yours may relate to some permissions problem or Datastage might have lost connection to unix as DS_JOBOBJECTS gives the path to home directory

If you call the sequencer from unix .......then you can clear the file while you call the job .

Hi all, I am running a job which extratcs data from one Oracle database passes trough a transform and loads into another oracle DB. Last week it ran at 100 rows/sec now its running at lessthan 1 row/sec. We tested the sql code on oracle DB its running fine. It seems their is some problem with datast...

I found the problem........We cannot have two parameters(?) unless we have two key columns....

Sorry guys ,....following is the correct query



Select
column a.
column b,
new coulmn
from
table A
where
(coulmn c=?)
union all
Select
column a.
column b,
new coulmn
from
table A
where
(coulmn d=?);

still i get the error