DSXchange

vinsashi wrote:table size was increased.

Think you need to increase the TEMP tablespace size

All you have to do is to read posts by Craig or me to get the logic.

Tanaya, do the following check.

select max(your_column_name) from your_oracle_table;

check the result whether it fits into range of SFLOAT.

Assuming only one instance of '_' occurs and you need only last three characters.

If index(column_name,'_',1) > 0 Then right(column_name,3)
Else column_name

how to implement the below rule in Datastage? i have a column "TransDate" the datatype is char and format is yyyymmdd yyyy should be start with "20" mm shd be value 01 through 12. what is your source? If it is a database use database function to convert into date and check if th...

Just wondering are you by any chance using 'User Defined SQL'

sequnum=(empno*2) - 1 I don't think "sequnum=(empno*2) - 1" would solve the purpose for the given sample data, considering the fact that employee number is not in sorted order. I believe "sequnum=(@inrownum*2)-1" would do for you. "sequnum=(empno*2) - 1" will solve the...

Could you post your job design and the complete error message. ie., the stage where you are getting the error, you can identify it by clicking show error or more buttons on compile window.

what are the write methods you are using in the target stages?

if the excel file has more than one sheet than converting to CSV will not work.

Subrat is the column COL2 is of number type or it is of Character type.

if it is Char then try using COALESCE(COL2,'0') and of course change the derivation in Datastage for this column to have string value.

Yes, the customer would be treated as two different persons unless you have set the commit size to 1 and using sparse lookup.

just wondering why not remove duplicates on customer before doing the lookup.

If you do not like to logon to Admin every now and then, Other way to check if the variable exists is trying to add the environment variable as a job parameter.

After full outer join, you have to use conditions(transformer or filters would do) to restrict records with match to first output, only in source to second output and only in referecne to third output.

1. I am not sure. We never faced any issue because of Citrix. 2. 45 Client licenses mean 45 concurrent DataStage client instances. it does not mean 45 Designer + 45 director + 45 Admin + 45 Manager. for example -- if user 1 opened 10 designers, user 2 opened 10 directors , user 3 opened 10 managers ...