DSXchange

No luck, Any other thoughts.

My question is this I am reading data from one table which is in x database and appending data to the oracle database this table is a partitioned table. so its not allwoing me to choose index mode.when i try to run the job its is giving the below error. Oracle_Enterprise_12: Indexes on table 'inv_sb...

Sorry, Actually My target is also view not a table.

Sorry, Actually My target is also view not a table.

Hi when i tried to load view into a table.(Basically the view is in one database and the target table is in other database) I am getting the below error can any body suggest what to do. Oracle_Enterprise_17,0: SQL*Loader: Release 10.2.0.2.0 - Production on Tue Jan 16 11:54:42 2007 Copyright (c) 1982...

Hi,


Can anybody tell me what stage we have to use for secure ftp

Thanks

Use a BASIC Transformer stage (the overhead for one row can be ignored) and use the DSSetUserStatus() function in a constraint or derivation expression. Search the forum for examples. We do not have BASIC Transformer stage . We have regular Transformer stage and it is not accepting any DSSetUserSta...

Run in a separate job, store the result in a file or in the job's user status area. Pick that up in the job sequence and feed its value to your job parameter in the Job activity. Ray, Can you tell me how to store the value in user status area?. What stage to use for that?. We are using parallel edi...

Run in a separate job, store the result in a file or in the job's user status area. Pick that up in the job sequence and feed its value to your job parameter in the Job activity. How to pick up the result from the file and pass it to next job in the sequence?. Do we need to use any special activity...

I need to store the result from oracle enterprise stage which always returns single value into a parameter. I have to use this parameter in other jobs.
Any help.

Yes,I am getting error on lookup stage.

I dont have this tab and I am using 7.5.2 edition on Unix.

And the datatype is also correct as table structure in database.

I did that but still its not working

we are using lookup stage

Hi, Here the problem is, your using a CHAR as a Key column and your checking the case sensitive or insensitive. Just check the key fields and select the option case sensitive and try out the result. Your key has a unspecific format. Just check the datatype and select the option of Case sensitive. W...

Hi-

Error when checking operator: Unrecognized type-specific format properties: {case=insensitive}; on key "column"
Error when checking operator: Unrecognized type-specific format properties:

What is this error? any idea on this one

Thanks