DSXchange

Hi Im using ODBC stage to extract sata from oracle table, all the fields are varchar, still im getting this warning mesage:

ODBC_Enterprise_144,0: Invalid character conversion found converting to ASCL_ASCII, substituting.

i tried a serach but couldnt get any help. please help me fix this.

Hi I have some problem when I use the LookUp Stage and Join stage. Following are the details: Source Oracle 10, target: Oracle 10. Im extracting data from 1 oracle table using an ODBC stage, then i use a look up stage to look up with another table (i use ODBCstage). Source query: select S.col1, S.co...

Check the character set in your data base side.

use:

select * from nls_database_parameters where parameter='NLS_CHARACTERSET'

also check your DS Director log. Especially the second log which has the environmental settings: Check the NLS.

use single quote:

StringToDate(Left(DSLink5.MaturityDate,10) ,'%dd/%mm/%yyyy')

check your to_date command.

select to_char(nvl(max(sysdate), to_date('10/10/2001 10:10:10', 'mm/dd/yyyy hh24:mi:ss'))) max_date from dual

I use a to_char function to convert the date to string if i use a ODBC stage.

you can use the Oracle load option parameter in your job but make sure your data is clean. If you have already staged the data in a dataset ot sequential file then use bulk loading option, because i have many times faced issues with index (being unusable -due to duplicate data). So before going for ...

Do a row count before going for a join stage. If the row count is very less use SQL query to join the tables, ot use a look up instead, go for join only if its necessary(very huge data/less space)

Hi

That was a very clear explanation, I will do more research and let you know about the performance. untill then I will keep this open.

Im sorry for the incomplete post:

My question is
1) which partition would be best for my situation:
amount(decimal), new_Seq (double), old_seq(double)

im just summing the amount column and groupin by old and new_seq column.

Hi I have a question regarding partition methods and performance. I have simple job that extracts data from an oracle table (three columns) and use an aggregator stage to sum and group and then load into an oracle table (i create the target table). oracle_stage----->agg_stage---->oracle_stage I trie...

Hi I changed the "Pre-Load file to memory" to Disabled and the job didnt have any problem. It generated sequence in correct fashion. I suspesct the file might be locked from getting updating and thats why it was reading the most recent value and generating the error. Or dure to less memory...

I changed the setting for "Pre-Load file to memory" to disabled and now the performance is very slow (100 rows/sec).

this is what we have right now:

when writing to a file:

Allow stage write cache -- this is not checked
create file --- not checked

under Update Optiosn

Bothe are un checked.

When reading:

Pre-Load file to memory:
Enabled --> is chosen. so do you want me to disable this and try.

"Is this hashed file the source for your surrogate key? If so this could be part of your issue. "

Yes. you are right. this file stores only the table name ans the column name and the surrogate key.