DSXchange

I'm thinking that's about as best as it gets if those are literally your requirements - every day a full refresh of all records for that year. I assume there are records for other years in the table?

So not actually populating the previous row but the current row with data from the previous row. That's just stage variables in a transformer. Since stage variables are evaluated top to bottom, you've always been able to hold on to any previous value from a row and leverage it in future rows.

mmanes wrote:When I read, discard the records.

You want them discarded or they are being discarded and you want to process them as nulls?

Trolling? Get real.

For completeness, can you tell us what the exact version you are running?

Sorry, don't have a good answer for you off the top of my head but did just want to point out that the days where you had a reason to avoid transformers are long gone.

OK, I'll bite... why "without a transformer"?

Is there an ODBC driver for Lotus Notes that runs under Linux 6.x? If so, would using that allow us to access our data? There certainly seems to be ODBC drivers for Notes on UNIX. I assume that would work for you but unless someone chimes in who has done this before, you'd need to confirm that with...

Thanks. Looks to be specific to Java and how you bind CLOBs into an insert which would explain why I'd never heard of / encountered it before.

OK, so pursue the Wiles/Wurlod variant then.

SURA wrote:I will still stand with my other points in relates with the data type. I have seen this error before for permission reason. But when i search in the oracle forums i do noticed, data type is also one of the reason.

Interesting... can you post a link to an example?

OSH? This is a Server job so no such thing here. Never seen data of any type cause this error, it's always either a lack of grants or the use of the wrong connection account that causes the table to not be 'seen'. And it should be an 'all or nothing' situation - either it sees the table and loads th...

It would have helped if you explained "what you need to do" in its entirety right off the bat rather then just ask about a part of the puzzle. At this point we still don't even know what that is.

Shouldn't be necessary... or do you not agree?

Aggregation. Not saying it's better but it is another method.

And what you have is not a "workaround" it is a resolution and I am marking it as such.