DSXchange

I am using Reject Link to capture any reject data that could not be laoded into the database. I am getting the error message "Oracle_Enterprse : Unable to insert a record into the table." "Orcle_Enterprise : The runLocally() of the operator Failed." We are running this job at 2 n...

Hi, We have Load Ready Dataset that is output of SCD type2 stage and we are laoding that setset into Databse table in another job using Oracle enterprise stage in upsert mode. Sometime data is loaded sucessfully and sometime loading gets failed by giving error "Unable to insert record into the ...

Just press 'Enter' at the end of the File.

I have created on Parameter Set that I am using in all jobs and it is working fine. When I am runing jobs through sequence, the values given in Sequence are not passed. It just takes the default values from parameter set.
Please help.

Using job parameter, it is working.

I am not hard coding. I am giving the parameter using Parameter GUI and its like #$DS_LAND#/surr_file.txt

When I give the full path of surrogate flat file in SCD stage to generate the Surrogate key, it works fine. But when I parameterize the surrogate flat file , SCD stage gives compile error. Please let me the reason. ex..var/spool/hs/land/surr_file.txt----It works fine. $DS_LAND$/surr_file.txt---It gi...

Hi,

My source data is 123 and datatype is varchar2 and length is 10
I want to store it as 0000000123 in the target data with datatype varchar2 and length 10.

I am using SCD stage . My input file is sequential file and reference file is Oracle table(lookup). Dimension update file is dataset. When there is a change in the type 2 column , it is generated the new record with new SK key but not giving the old record that has been expired.Please give me idea h...

Romy wrote:you can try using column export stage. The Column Export stage exports data from a number of columns of different data types into a single column of data type string or binary.

It helped me...
Thanks a lot...

How to concatenate two column values to generate single column without using Transformer.
I am doing a lookup and returning 2 column and now i want to concatenate these 2 column and store the output in one column.
Please help me.