DSXchange

That works!!

Thankyou All

Forwarded this to DBA for the select permission to the below data files as mentioned in the document.

The problem was with the SQL bulk loader which needs specific permissions as I used LOAD in oracle enterprise.

I need to truncate and load the table same time in the same job everyday. So in the target I used Oracle enterprise stage with write method as load and write mode as truncate. Please let me know whether this works for my requirement, I tried to do this use the userid of the table owner but I get an ...

In the stage variable do I need to find the count of Rows or how can I do it?


Thanks

I have a field customerInfoID which has duplicates like 101,101,101,101,102,102,102. The output I need is 101,4 and 102,3 i.e row count of each customerInfoID. This can be done through aggregator but I wanted to do this in transformer to avoid using aggregator please suggest me the function which ha...

Thanks Jwiles

Is there any stage other than transformer to change datatypes,field lengths and giving values to nulls?

I have a number of issues with the fields before doing a lookup so need a stage for the above changes.

Used transformer but that is increases the technical weight to the job.


Thanks

Thanks Chulett.

I will follow the same for insert only as below and I assume that is the same for update only also just change in the user defined update statement.

My job runs fine in Development and Test but fails in production.

The error starts at oracle enterprise stage which is

"Failure during execution of operator logic" and that is the source.


Please suggest me if any changes are required to run the job with no errors..



Thanks

Thanks for the Information.

Primary key was not defined earlier , now its defined.

If its only insert for a table then Do I need to use insert statement in the update also..as there is no insert only?

I am using oracle enterprise stage to load the tables(to insert new records and update the old records) The properties I used in the target are Insert SQL=insert into table name (column1,column2...) table= tablename UpdateSQL=Update tablename set column1=orchestratecolumn1...... upsertmode=auto gene...

Searched all the files but no luck.

I looked into a folder named IS_CASS Files in C:\ but did not find the job.

There are .tar files named CASSDBM1,CASSDBM2...and so on...untared them but cannot see any .dsx file.

Yes I see a .dsx file in that folder,I imported the same but that tutorial has no CASS job It has only investigate,standardize,survive,unduplicate.


any other info please?

Thanks Istsaur.

which Installation folder is that?

Is it under documentation?

Thanks for the information!!

CASS does the standardization of address and If the input has a name then name should be standardized with standardize stage.

If the case is the input has only address1,address2,city,state,zip
Do I need standardize stage or Just the CASS stage?


any info please?