DSXchange

Such a migration project will, of necessity, involve a lot of thought about reorganizing the tables in order to take advantage of differences in architecture. Bah... one part of the organization here is in the process of same. First step? The migration of the Oracle database to TeraData unchanged a...

Two lefts and three rights, Arnd?

DQuote or SQuote, there is no Quote.

No. Use the ellipsis in the Key Expression editor for a list of valid contributors.

You could pass the stage variable down a link and use it in the lookup of a downstream transformer, however. But that would just put you back to doing the look up from the input link.

What datatype did you 'substring' into?

Really more of a DBA question. We don't know your structures, indexes, data volumes, etc and can't see your explain plan. The whole Toad part about the data starting to return instantly and 'select count(*) from' stats are fairly meaningless, unfortunately. Check with your DBA. Perhaps you need a 'b...

Hard to say, most causes of something like this are beyond your ability to fix. Best to open a ticket with your official Support provider and enlist their help.

I don't think your firewalls would cause any of this. Another question - what Update Action are you using in the stage?

How much greater than 1 are you using? And what is the Transaction Size you are using?

singhald wrote:can i store more than 2 GB data in hashed lookup now without creating 64 Bit hashed file.

No.

crouse wrote:Schema Name is the 5th parameter to populate on the Properties tab.

[sigh] I meant in his reply. *I* know where in the heck it is.

knowledge wrote:I was using automatic mode but have to use manual mode since my database and datastage is residing on diff server

I use Automatic mode with my database on a different server than DataStage without issue.

I don't see a value for 'Schema' in the ORAOCIBL stage listed.

Right, some of those fields are only used in Manual mode. Property Help explains all that.

knowledge wrote:I will talk to my DBA, but same table with same parameter I could load by OCI stage but not with bulk loaded

Requires different grants, from what I recall.