Hi All,
I am using Datastage EE(7.1),i need to extract the data from Multi Dimensional Cube(built in Sybase).Is Datastage has capability to extract data directly from a Cube?
Any ideas....
Thanks in advance,
Beeram
Sybase Cubes
Moderators: chulett, rschirm, roy
Hi,
AFAIK,
If you can do it via regular sql select, yes.
If it requires special handling or connections it might be another thing.
By the way you will probably need a certified answer so please post what your support provider's answer is.
Good Luck,
AFAIK,
If you can do it via regular sql select, yes.
If it requires special handling or connections it might be another thing.
By the way you will probably need a certified answer so please post what your support provider's answer is.
Good Luck,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes, though you may need user-defined SQL if you need to constrain on dimensions, for example. Haven't done this with Sybase, but have done so with SQL Server.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.