DSXchange

Thanks guys for all your inputs. This issue has been resolved. The issue was in aggregator stage but everything was ok in stage - I mean mapping, properties...... So, I deleted the stage and newly inserted stage & did mappings. Its working fine now. I dont know what was the problem; may be job ...

Hi Arndw, The log is not showing the stage in which error is generated. The error is like:- main_program: APT_StatReducer:field IMPO_FSPR_EME_RES_OP_EUR11 is already present in the output interface schema. Abhishek, Yes, I am using aggregator stage: Here the input schema field for IMPO_FSPR_EME_RES_...

Hi All, We are doing testing for a convertion project. While running a job I got a strange following error: main_program: APT_StatReducer:field IMPO_FSPR_EME_RES_OP_EUR11 is already present in the output interface schema. This is first time I am facing such an error. I am working on same. Meanwhile ...

You canot read the data in this format; you need to remove that extra double quote.

It is recommendable to use Windows 2000 Professional or Windows XP rather than Windows Vista.

What is Blade?

I guess we cannot connect to Windows server through ODBC from LINUX Server.
ODBC allows only Oracle,DB2,Infromix,Sybase..... but not Windows.

You are right, keychange option is used when sort mode is: sort . ClusterKeyChange is used for sort mode = Dont sort (previously sorted).

Thanks Mike...

Ray, I think so, we have installed correctly; we are able to connect to SCOTT/TIGER schema on Oracle Database server which is on remote. Actually we dont have any DBA here, we installed ourselves the Oracle Client referring manuals. Ray, would you tell me is there any way/test to know Oracle Client ...

Hi All, We have newly installed Inofrmation Server 8.0 on AIX5.3 OS. Alongwith we have installed DB2 Metadata Repository . I have followed the documentation to build connectivity between Datastage and DB2 but failed. I created SAMPLE database on DB2, On server m/c I can work on the tables, but on da...

Hi All, We newly installed Information Server 8.0, we need to give oracle connectivity through ODBC; Oracle is on remote server. We have modified all the parameters in configuration files: .odbc.ini, uvodbc.config & dsenv. We were able to connect to the Oracle database, we can import metadata. B...

Use function DaysSinceFromDate & then divide by 30.
Take o/p column in integer type.
You will get the required o/p, I guess.