DSXchange

Hi We have created two user accounts on our DS 8.1 servers dsadm - which is the main admin account. and bchusr - which is the batch user account which is used by most of our scheduled jobs. individual developers use this account to login to DS and view logs, run/create jobs etc. See the group member...

Gentlemen ...I found this requirement in one of job advertisements on the internet.... Job Description: 5+ years of Datastage Administration & Development ExpExp with Datastage 7.5, 8.1Will be upgrading to 8.5 version Parallel Extender, Parallel drop, Information AnalyzerExp with Parallel Drop, ...

Hi One of my team members was asked this question in an interview. She is no longer with us obviously. I was wondering if it might refer to keeping or dropping fields in a parallel job ....something like this - http://mike2.openmethodology.org/wiki/Ascential_DataStage_Parallel_Modify_Stage_Programmi...

Hi We have not yet fully migrated to 8.1. Our DEV and PROD environments are still 7.5 but QA, UAT and IT have been migrated to 8.1 So we use version control to save the 7.5 source and deploy to 7.5 environments. Then we export the 7.5 jobs, import them to 8.1 DEV environment and use 8.1 ISM packages...

hi I am looking to do what you are doing. We have not yet fully migrated to 8.1. Our DEV and PROD environment is still 7.5 but QA, UAT and IT have been migrated to 8.1 So we use version control to save the source and ISM packages to deploy to other 8.1 environments. Now I have been asked to use the ...

what is parallel drop? Could any explain?

Thanks for you reply. I am using 'Varchar' for sourse date from oracle stage and contiuting that 'Varchar' thoughout the job. I used 'Date' in the final update in the Oracle stage. I also I am using Iconv and Oconv too. When I used Query TPE'Generate Update action from Options and Columns tabs' and ...

You need to explain what all those "not working" statements mean. What's not working about them? Are you getting errors? Also, are you ensuring that your date is in the format that matches the mask used in the generated DML? IF date is in date data type. Getting "DATE conversion fail...

Hi, I Need to update ORA table with date and some other fileds after aggregator stage. If I define Date as "Date" data type it is not working, but if I define "Date' as a Varchar it is working, but final upadte is not working after aggregrator stage. If I remove that final update(ORA ...

Anyone please help me with this issue..

Franklin,

Thanks for the answer.

But we cannot do anything with the file now. client is not ready give new file or allow us use mainframe file.

chulett wrote:Did you try convert?

Code: Select all

Convert(CHAR(255)," ",YourField)

Yes i tried that. I got that from one of the previous post. But it did not work.

I have a text file in which we have some special/junk characters. the special charater is something like box whose ascii value is 255. When i checked, i came to know that the file is from mainframe and during coversion they have some mainframe low values left as is. Now my problem is i want convert ...

Just wanted to mention that the above configuration (DS 7.5 with oracle 11G) is working for us for the most part but atleast one of our jobs is failing for no apparent reason with this error message - "Could not determine version of Oracle for which to partition" It is a parallel job using...

I checked my configurations throughly and there is nothing wrong with them.
Now what ?

What do you guys make of this error in am getting in the enterprise stage ?


>##F IIS-DSEE-TFIR-00003 13:24:24(002) <main_program> Fatal Error: Duplicate class registration for: APT_HostFileNameImpl