DSXchange

Hi ,

Hi,

There is no conversion and data is simply moved over.
NLS is not installed, is it possible to move those characters without NLS?
Can we get those characters into the oracle by changing the NLS_CHARACTERSET?
Currently the the value for NLS_CHARACTERSET IS WE8IS08859P15.

Thanks

Hi,

There is no conversion and data is simply moved over.

Thanks

Hi ,

NLS is not installed with the data stage.

SELECT USERENV ('LANGUAGE') FROM DUAL;
Returns --> NLS_LANG=American_America.WE8ISO8859P15

SELECT * FROM NLS_DATABASE_PARAMETERS
the value for NLS_CHARACTERSET IS WE8IS08859P15

Thanks

Hi Sai,

Changed the datatype of this column to VarBinary, still the same problem...

There is one more field with string and excel internal date like 'abc 38895'.
So i thought to do the conversion with the ETL.
I tried with Oconv(iconv(1900-01-01,"D-YMD[4,2,2]")+ 38895,"D-YMD[4,2,2])") ,but its not giving the correct date.

Hi All,
I have to populate an oracle table from an Excel sheet.
Converted the Excel sheet to a csv file, using sequential file stage to read it. Date field in the excel sheet in excel format ( like 38895) .
How to convert this to Standard Date Format ( YYYYMMDD) ?
Any help is appreciated..

Thanks Craig n Ray,

Okay i will Turn Write cache off.
Shall i put write cache size as 999MB?
Is there any other way to improve the performance of this job?

Thanks

Hi Gurus, i have a 64 bit hashed file, created by using the code RESIZE hashedfile_name 18 13671881 2 64BIT. after loading 800000 records, the job is getting aborted with the warning "add_to_heap() - Unable to allocate memory" . i have sufficient space in the disk. any help is appreciated....

Thank you All,
iam working on a 2 CPU peoplesoft EPM.

[quote="ray.wurlod"]Where is the slowness? - you need to verify that the slowness is in the Hashed File stage rather than in the extraction piece. Much of the slowness loading large hashed files on disk is the randomness of the operation (about which there is nothing you can do). Each new ...

Hi All, i have created a 64 bit hashed file RESIZE hashfilename 18 14765651 4 64BIT. Iam loading data to this hashed file from a table which contains around 50 million records. This job is running very very slow, after 24 hrs it loaded 10 million records only. Now its loading with 150 records per se...

Thanks

But it seems that the BASIC transformer will be unable to work on the parallel grid we are using. Who said? Of course it can - you just need to make sure it runs on a node where the DataStage run machine is installed. You can use a node pool or a one-node configuration file. for some reason they wa...

Recently I have been developing a parallel job to populate a time dimension. The time dimension has the usual columns such Date, Year, Quarter, Month name, Month days remaining, weekday number, weekday name, Year days remaining, week no etc I was using the BASIC Transformer to obtain all the above. ...

On what day does a week start? How is week number 1 in a year defined (all weeks must have seven days, so "starts on Jan 1" is not a good rule). Solution #1 Look at the Transform WEEK.TAG and the WeekTag routine that it calls. These document one business rule (from memory, week begins on ...