DSXchange

Hashing is a widely-used technique for reliably (repeatably) selecting one from a finite number of alternatives based on a given value. In parallel jobs, hash partitioning chooses one from the finite number of processing nodes based on the combination of values provided as "key" on the partitioning ...

Whenever you see "internal error" you need to involve your support provider and, through them, the vendor.

I disagree about your assertion about "too large" - any lookup will be aided by the primary key index, or you can pre-build something like a Lookup File Set. As to your actual question, you just have to wear the slight difference in efficiency on those days where there are more updates than inserts....

That's because it's a timestamp. There is no automatic conversion to date - that's what the error message is telling you. Therefore you can not simply assert that the column is of type DATE and expect to import from an Oracle TIMESTAMP into it. Put another way, your metadata must accord with what's ...

Why?

Your specification is quite specific about needing one lookup and a second conditional lookup. Therefore you need two. You can, of course, make the second one conditional.

You can not "repartition the entire Data Set" without deleting and re-populating it. Therefore you have to ensure that the appended rows are partitioned identically to the rows that are already in the Data Set.

This is the same answer as the one I gave yesterday.

Have you checked and double checked that you are providing the correct user ID and password? After all, the error message referred to an authorization specification, rather than to a connection issue. Are you doing anything fancy with the ODBC connection string?

Sequential files don't have/enforce data types - they only have "text". In the ELSE side of your IF expression you are providing no fractional seconds whereas in the THEN side you are providing five. No wonder Oracle is confused. What is the data type of this column in the Oracle table, as imported ...

U (a different poster) may not, but will siva7143 ?

Correct spelling of the second person personal pronoun is "you", not "u".

Welcome aboard. It's time to become a detective. NOCHECK appears in the control file for sqlldr that is generated by the Oracle Enterprise stage - you can find and view this file in the directory you specified in the stage. Now backtrack into your design and find the stage property that causes this ...

Hi.. Thank you very much for your solution. But am confused, how can we do left outer join using transformer stage?? Do we need to check for Isnull condition in constraint division?? The natural behaviour of the Transformer stage is to perform a left outer join; NULL is returned from the "right" (r...

It is documented that two adjacent Modify stages is not supported. Place a Copy stage between them if you need two.

Yeah? What about 130 and 1460?

Welcome aboard. Assuming this is a parallel job, since you posted in the parallel forum, you use a Join stage. If it is a server job you can only do a left outer join, using a Transformer that has a reference input link. However, it is easily provable that reversing the sense of left and right allow...

Routines in DataStage server job is a class that includes before/after subroutines and transform functions.

Put another way, Routines is the name of the root node in the Repository in which before/after subroutines and transform functions are stored.

At least prior to version 8.