DSXchange

Try to handle the null.. may be by using modify stage.. or try to get the rejected records in a text file and read from unix (from putty) the data might have some new line character, in that case try to use a chr function to suppress it. For example, when u read the file from unix it should be like ...

try to change the data type to double (leave the length empty), check the edit column meta data

Hi I have a situation, where i need to find if the job has completed (OK or with Warning) or Failed. That is, I have a main sequence in which I have a first Job Activity (JA1), if JA1 is OK or completed with Warning then it go to JA2 and JA3, If JA1 failes then it should abort. And similarly if JA3 ...

If you use oracle as source, then use a NVL function to conver the null values to something else, or i think you can use NullToEmpty or NullToValue function in the transformer.

I checked int he oracle stage, but i do not have that option. Where do i see that?

Im using Oracle Enterprise stage and in options i see only 2 properites:

OutPut reject Records and table has Nvarchar/Nvarchar, i do not see the index option there. Please let me know if im looking at a wrong place.

Thanks for your reply, Now i set the variable in the job level and its working. this is how I set the vairable. Job Properites windo / Parameters tab -- add the environment variable APT_ORACLE_LOAD_OPTIONS and in the default value section, jus type the following within single quotes. 'OPTIONS(DIRECT...

When you create a file you deliberately specify a delimeter (may be a pipe symbol, or some other) and use the same delimiter in the job that read the file. Some times the data source might have the defaut delimiter that you use, and this might cause some problem, For example if the source data has a...

I believe when we set DIRECT = False, we use the conventional method which uses the Insert statement while loading. but where as when we set DIRECT = TRYE oracle uses direct path load method which directly writes to the data base files. please correct me if im worng. Now i set the environement varia...

Hi Im trying to load an oracle table, im using Oracle stage as target and ODBC as a source. The target table has several indexes on it. When i load the table i get the following error message: Oracle_Stage: Indexes on table 'Oralce_Table_Name' preclude direct parallel loading unless an index option ...

check your data type.

I think you have a input column that is not defined in the output or out put column that not defined in the input, I would try to check the meta data, or try to check the properties in the look up stage for reject.

When even you import data from any files, please make sure you have the proper format, i mean delimiters, some times the data might have the delimiter in it and this may cause some issues. For example, we use pipe delimited files (|), normally the data that we get wont have this, when we create the ...

This is really amazing, when everybody share their experience and expertise. Thank you all for your wonderful ideas, keep contributing to this thread.

Hi We have parameter file that contains all the parameter and we use a server routine to call the parameters and pass them in the job sequences. so when ever we change the environment we just change the entry in the parameter file and use it, this method works fine., but my question is: Is there any...

Thats right, also make sure that when you have single quote (') you use forward slashes (/).