Sparse lookup in TeraData Enterprise

ag_ram · Post by **ag_ram** » Fri Jun 29, 2007 7:19 am

Hi Folks

Is it possible to have Sparse lookup on TeraData Enterprise stage ?
Is there a Workaround

ray.wurlod · Post by **ray.wurlod** » Fri Jun 29, 2007 7:56 am

No. Sparse lookup is documented as only being for DB2 and Oracle.

No, unless you're prepared to spend the time and effort to create a stage with that capability, or spend megabucks paying IBM to do so.

bcarlson · Post by **bcarlson** » Fri Jun 29, 2007 8:30 am

So this isn't something that they have fixed for Hawk?

ray.wurlod · Post by **ray.wurlod** » Fri Jun 29, 2007 1:25 pm

It can't be fixed, it wasn't broken. It's working as documented.
Page 239 of Parallel Job Developer's Guide version 8.0 says DB2 and Oracle only.

bcarlson · Post by **bcarlson** » Fri Jun 29, 2007 3:10 pm

ray.wurlod wrote:It can't be fixed, it wasn't broken. It's working as documented.
Page 239 of Parallel Job Developer's Guide version 8.0 says DB2 and Oracle only.

Sheesh, you sound like a lawyer or a politician.

One man's bug is another man's feature. Okay, so 'fix' may not be the right term. Do you know of any plans to add 'sparse lookup' capabilities to the Teradata Enterprise stage?

Brad.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 29, 2007 3:49 pm

That, sir, was a terrible thing to say!!!

(I know of no such plan.)

keshav0307 · Post by **keshav0307** » Sat Jun 30, 2007 7:09 am

using ODBC stage, you can do sparse lookup on teradata table.