DSXchange

Search for 'all terms' and put in something like "oracle log location". It been discussed here a number of times.

Search for your actual error text, the 'is not appropriate' bit - it's been discussed here a bajillion times.

I'm thinking there was a pretty strong implication there that whatever flavor of quotes you were using were wrong, so try the other.

And before Ray wakes up and whacks us:
:D

Basically, that all sounds fine to me. 1. A new record wouldn't get a hit on the hashed file, so it seems like a simple NOTFOUND link status would tell you a record is new. 2. Yup. 3. For any inserts or updates you'd want to update the hashed file with the new CRC32 value so you don't have to do it ...

No. You have to understand the (and I hate to use this word) 'limitations' of a 32bit CRC value. Plus how to properly leverage it to detect change in a Server job. The way we've done it which works just fine is you store the CRC32 value for the fields you are tracking changes against per natural key...

Post your configuration. Either that or start removing the 'non essential' ones one by one until it works.

You can also use the Execute Command stage in a Sequence job.

I'm confused. Why would you care if 2 out of 100,000 records had the same value in the seven data fields you are concatenating and CRC32'ing unless those records had the same natural key? Is that what you are saying?

ds_developer wrote:the CFF stage cannot be used as a target in the Server edition - it does not support input links.

Shirley is using a Server job.

jiegao wrote:My question is if link1 and link2 are within the same transaction.

That depends. Two OCI stages? Two transactions. One OCI stage? One transaction.

Typically, the problem occurs when there is no conversion and data is simply moved over. As noted, correct NLS_LANG settings on each end are critical.

Don't be sorry - don't hijack. Start your own thread and if you feel it helps, post a link back to this one. And when you do, post the error(s) you received, even if they are 'the same'.

Here's a crazy thought - why not explain to us in words what this is supposed to accomplish and then let us know what's not "working properly" about it?

Pavan_Yelugula wrote:But Recently i heard that this order can be changed by changing some entries in the Registry... In the sense by tweaking the registry we can make the constraints to execute first followed by stage varaiables and so on...

Umm.. no.