DSXchange

The only way you're going to know if a 'missing' file shows up out of sequence is to track the filenames that you have processed. Any kind of 'day - x' sweeping is going to be prone to error. I would suggest you capture the filenames as you process them. Check 'new' files against the list and only p...

Use a single Oracle stage.

Man, I really should stop posting first thing in the morning.

See what happens when you go away for a day and don't check in on the kids once in a while?

kumar_s wrote:If you need to read only first line of the file, you make use of 'Read first n rows' option available in the Sequential stage and set it to 1.

Interesting. In this thread people claim there is no such option.

Do you have an xsd for this? Import the metadata via the Manager and it will create the XPath expressions for you that you need to create it.

Close but no cigar.

Perhaps that's what I was thinking of.

Kumar - search the forum for the use of the VERIFY.SQL command with the FIX option.

Isn't there a property in the PX Sequential File stage to skip the first X records? Seem to recall that...

The gist of it is in Rasi's post. Basically, you are on the receiving end of every insert, update and delete from the source system. You can then use that information to drive the work you need to do in your target. Problem is, you can't 100 percent rely on what 'action' you get from CDC. In some si...

Without something upstream feeding deltas to you - like the CDC process built into Oracle or other third party utilities that provide similar functionality - then you'll have to do all the work of Change Data Detection in your jobs on your own. And yes, this involves preloaded hashed files of curren...

What kind of patch, Kris? DataStage patch? Windows patch? Where did you get it from?

For someone facing the same problem in the future who comes here and searches for answers, giving a complete solution can help them out.

You can use the Update action of 'Truncate table then insert' to create a job that just does the truncate for you. It can then be included in your jobstream (via a Sequencer job, for instance) just before your bulk load job. Unfortunately, a failed load will not be restartable without going back and...

My userid is configured for cron.allow. I would really appreciate if can help me. Martin - Help you how? Are you having a problem? If so, please state it, otherwise how do we know how to help you? Otherwise it literally is as simple as clicking on 'Add to Schedule', then 'Every' and entering a time...