DSXchange

Hi.. I am working on migration project.i.e.DS7.5 to DS8.5. In the Datastage 7.5 the dsrecords is working correctly and getting dataset count. But in the datastage 8.5 the dsrecords is not working and getting error. Please let me know , is there any settings we need to do to make it work properly. $ ...

I am using Teradata connector stage. Array size i have mentioned like default 2000 and the Maximum buffer size assigned as "0" if i do right click it says default value as zero. After loading 600000 rows job got aborted like no more room space, but the space is available in Database. One o...

I got the same issue. Could you please let me know how it got resolved

In transformer i am facing this issue.

Thanks
Prakash

My problem was not resoved by searching in the forum. So again i posted in the form..
Please send me the suggestion for this problem

Thanks
Prakash

HI All,

I am having a problem

Tr_DAT_MAJ_SOCLE: When checking operator: Dropping component "DAT_MAJ_SOCL" because of a prior component with the same name.

Could you let me know , for what reason we are getting this warning.

Thanks
Prakash

My Source is flat file


Thanks

Hi

in salary column, i have 10 rows . In that two ,three fields are empty values. But still i am not getting the correct result. So now you can help me about this

Thanks

chulett,

I want to explain the job.

my source has three columns. ID, Name and salary.
the datatype of these columns is integer, varchar and integer respectively.
i checked option, Nullable is Yes for salary column. But still i am not getting desired result.
can you help me about this.

Thanks

Chulett, Thanks for your quick reply and i have mentioned as you are said , but still i am not getting solution for this. If IsNull(a.SALARY) then 999 else a.SALARY. Here is the a is the source link. if i put this condition , i am not getting 999 in the place of null, i am getting only null in the n...

chulett,
Thanks for your reply. i am putting the following syntax

If column=isNull then 999 else '0'

Please correct if i am wrong

Thanks
Prakash

Thanks for everybody. I know NullToValue in parallel but in server if i use IF THEN ELSE , I am not getting the desired value.. i am getting only null values in place of null values in the target. so please reply..

Thanks

Hi All i have salary column , but few fields are null. If salary is null then i want 999 in the target otherwise i want the salary itself. Ex: Input: ID|NAME|SALARY 101,RAY,10000 102,CHIRS, 103,RAM,20000 104,JESSY, Output i want as : ID|NAME|SALARY 101,RAY,10000 102,CHIRS,999 103,RAM,20000 104,JESSY...

Hi..
can anybody guide me, i want to install Datastage 8 into my personal computer, so what are the configuration to be done and tell me system configuraion for installation .

thanks
Prakash

Hi..
can anybody tell me , What is the difference between Stored Procedure and View?

Thanks
Prakash