Page 1 of 1
Sparse lookup in TeraData Enterprise
Posted: Fri Jun 29, 2007 7:19 am
by ag_ram
Hi Folks
Is it possible to have Sparse lookup on TeraData Enterprise stage ?
Is there a Workaround
Posted: Fri Jun 29, 2007 7:56 am
by ray.wurlod
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.
Posted: Fri Jun 29, 2007 8:30 am
by bcarlson
So this isn't something that they have fixed for Hawk?
Posted: Fri Jun 29, 2007 1:25 pm
by ray.wurlod
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.
Posted: Fri Jun 29, 2007 3:10 pm
by bcarlson
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.
Posted: Fri Jun 29, 2007 3:49 pm
by ray.wurlod
That, sir, was a
terrible thing to say!!!
(I know of no such plan.)
Posted: Sat Jun 30, 2007 7:09 am
by keshav0307
using ODBC stage, you can do sparse lookup on teradata table.