Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
ag_ram
Premium Member
Posts: 524 Joined: Wed Feb 28, 2007 3:51 am
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
bcarlson
Premium Member
Posts: 772 Joined: Fri Oct 01, 2004 3:06 pm
Location: Minnesota
Post
by bcarlson » Fri Jun 29, 2007 8:30 am
So this isn't something that they have fixed for Hawk?
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
bcarlson
Premium Member
Posts: 772 Joined: Fri Oct 01, 2004 3:06 pm
Location: Minnesota
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
keshav0307
Premium Member
Posts: 783 Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia
Post
by keshav0307 » Sat Jun 30, 2007 7:09 am
using ODBC stage, you can do sparse lookup on teradata table.