DSXchange

Adding a dummy column is manual work and may not work while automating your process. A food for thought

How are you creating the hashed file? If from a flat file, make sure you have quote character as (") so that they dont get transfered to the hashed file.

No Kim. Not making fun. Its really nice.

I guess I have hit the limit to the amount of help I can provide sitting on this side of the screen. Get someone else involved who is present at your site. If to no avail, contact support.

Are you both having fun with the poor guy Bhaggu, what exactly do you want to know. A single processor is required for your stuff to execute. In px jobs, the number of processors is irrelevent per se. Its the number of nodes that decides how much parallelism will be incorporated. Is this an intervie...

O comeon, just having fun

Really, think again

Change the datatype of your target stage to BigInt and see if that helps. That number is too large for integer datatype.

Thispost might help. Read Ray's second to last reply.

That is because you are reading it as char. Read it as numeric. What error are you getting if you read it as numeric again?

Use TimeFromMidnightSeconds() function to get the time. But this function requires seconds since midnight and not milliseconds, so you will have to divide you will have to divide the number by 60 to get seconds. So you decide, can you live with getting time upto seconds or not.

Send the stream down into remove deplicate stage and set the property to "Retain Last" keyed on the grouping key. Thats a workaround.

So your chotu huh? Hehe, this is nice.
Kim sounds like a nice mamu.

AsInteger() function in transformer does'nt work for you? Plus I dont get it, why were you having problems reading the integer from oracle in the first place? Is it really an integer or out of bound decimal number?

What error message does it throw?