DSXchange

Can't you use your [3] and [4] for box number and house number respectively ?

If the number of occurance is small, you can write in seperate output links or split into columns and pivot them.

Set a database level trace to see what is happening.

From that you can trace everything including the offending object, data and its code.

What happens if you run with a single node config file ?

Define "number of columns".

What about stage variables, source, target, columns not taken to target etc etc. ?

Remove all your columns returned from Select and do a

Select 1 x
FROM ........

and see what happens.

Build the columns from there. Or do a viceversa.

Appears like interview questions. Are they ?

Did you search?

Are you using a LongVarchar or LOB ?

Are there any special characgers in the data?

Oh !! Noticed just now.

But the o/p was saying about static ones !!??

Do you recalculate the static hashed file structure based on daily append or it is static all the time.

Check whether the increase halts after some time and you appear to have crossed 2GB size.

Is your DataStage and Hashed file set on 64 bit architecture ?

Do you recalculate the static hashed file structure based on daily append or it is static all the time.

Check whether the increase halts after some time and you appear to have crossed 2GB size.

Is your DataStage and Hashed file set on 64 bit architecture ?

It is due to difference in metadata as the job aborts while compiling. Not sure how.

Why is your lead not accepting?

Did you measure the time if you start with a blank db2 table against it being fully loaded ?

chulett wrote:What, you don't like the "guess what I am thinking" game? So many opportunities to play it here.

Craig,

You are either very happy today or in verge of a total breakdown.

Was it working before ?

Is it new ?

Does it always happen?

Can you import any metadata ?

And where is the to_date ? ... Hi Sainath and DS, This is my mistake.Anyhow I got a new error again... "Oracle Error - OCI_INVALID_HANDLE" How may i handle this. Without you posting the full SQL it will not be possible for anyone to assist you efficiently. All will be guessing. It is more...