DSXchange

Make sure host machine is having enough memory (RAM) and disk space to support two guest machines (Varitual machines), other than this you are fine.

Replace with Parallel Tranformer Stage, you will be fine or try to find that file in tmp directory and delete it.

Open Parallel Job -->expand Processing Palette --> right click & choose Customization --> Customize..--> under repository item & under Stage types expand Parallel and highlight BASIC Tranformer and move it to right side window (Current Palatte groups and shortcut items:).

Ask your DataStage admin, he / she should be able to provide information.

"abcd,ef,ghi,jkl,123,4rf,gfr,ser[6,2] = ef

Assuming data string is left justified, fetch 2 bytes from string position 6.

/Ascential/DataStage/Configurations/default.apt is the location of configuration file.

to add more power to data processing, you need number of nodes and also below information

fastname <Host Name>
resource disk <Datasets path>
resource scratchdisk <Scratch file path>

Hi Ray, Thanks for pointing me to look at logs. What I found in PS logs is main::WriteColumnFile: Unable to get list of columns using catalog function 'SQLColumns' on table 'MARKET' due to: CoreOdbc::_ExecCatalogFetchAll: Problem encountered during FETCH: ------- DBI Result Information ------- SQL S...

Hi Ray,

I tried to import metadata one-by-one, still same error.

What wonders me is, PS imports metadata for some tables from same schema.

Is it ODBC driver or ProfileStage setup or something else I ignoring or missing, any idea what I am going wrong.

Microsoft Visual Studio 2003 will work.

First convert your multi-format date to standard MM-DD-YYYY format in 3 stage variables. If your incoming year part 2 bytes then standardize to 4 bytes year part. If month part is like JAN / FEB then standardize to 2 bytes numerical part. DD-MM-YY = 09-11-08 (standardize to 11-10-2008) DD-MON-YY = 0...

Those kind of files you won't find on the DS Server, if you are trying to make a copy of License.xml file and want to use for your local installation, ask you DS Admin or whoever responsible for maintaing DS Server at you client place.

In shared container got to Output tab there you will find Map to container link drop down link, open it and select the link coming out of Container and Validate it

Sorry, I didn't mention one thing.

I selected 20 tables and able to import for 4 tables but for rest of tables I have error message.

Yes I have SELECT privileges and able to query same table from TOAD without any issues.

Thanks
Srimitta

Hi All, Importing metadata from Orcacle schema is failing with below error message, any idea on how to resolve this. I am able to import metadata from SQL server DB with out any errors. Unable to get list of columns catalog function 'SQLColumns' on table Repository is Oracle Schema Connection is ODB...