Showing posts with label links. Show all posts
Showing posts with label links. Show all posts

Friday, March 30, 2012

Help on Sybase Power Designeer

Hi,
I want to learn Sybase Power Designer...but i dint find right meterial till
now .
Can anybody give me the links for the tutorials or articles..
Thanx for the help guys
KumarTry the sybase website - and then the appropriate sybase newsgroups.sql

Friday, March 23, 2012

Help on ETL

Hi,
I'm still new to datawarehousing and right now I'm stuck on ETL. So can
anybody give me some links to a good online resurces about ETL technics.
Thanks,
Marius
Marius,
I have publushed the C (and cobol) code you need to emulate to load large
star schema DWs on my personal web page www.peternolan.com. Can't do much
more for free than publish the code you need to emulate..;-)
I have also published a lot of other materials there...
If you are using SQL Server you might want to use DTS.
Best Regards
Peter
"Mark00" <mstoncius@.hotmail.com> wrote in message
news:O%23yTWoydFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I'm still new to datawarehousing and right now I'm stuck on ETL. So can
> anybody give me some links to a good online resurces about ETL technics.
> Thanks,
> Marius
>
|||Hello Mark,
Check out the following links. These will help you get started using
DTS as an ETL development platform.
The link below is a great overview of DTS designer
http://www.sqldts.com/default.aspx?278
DTS white papers
DTS Programming Techniques Used in Microsoft SQL Server Accelerator for
Business Intelligence
http://msdn.microsoft.com/library/de..._dts_ssabi.asp
Best Practices for Using DTS for Business Intelligence Solutions
(updated web version)
http://msdn.microsoft.com/library/de...tbpwithdts.asp
Hope this helps
Myles Matheson
Data Warehouse Architect
|||C and COBOL? Are the comments written in King James english?
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:e5%23ano0dFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Marius,
> I have publushed the C (and cobol) code you need to emulate to load large
> star schema DWs on my personal web page www.peternolan.com. Can't do much
> more for free than publish the code you need to emulate..;-)
> I have also published a lot of other materials there...
> If you are using SQL Server you might want to use DTS.
> Best Regards
> Peter
> "Mark00" <mstoncius@.hotmail.com> wrote in message
> news:O%23yTWoydFHA.3808@.TK2MSFTNGP14.phx.gbl...
>
|||Hi JT,
That's the 'free' stuff that includes many of the features needed to
build a DW...we used it in many clients in the 90s.....(I've been
doing DWs since 1991 when C++ was a novelty and Java was a long time
from being invented...and cobol was still lingua franka of all
computing....) I published it because I am often asked how to build
the ETL code to load type1/2 dimensions, facts, summaries etc....my
answer was..."here is the code you need to replicate the functionality
of for free." I can't do much more than that for
free...(LOL)....also, because there are so many ETL tools, and they
have collapsed their processing and data structures, it's almost
pointless to publish code that loads DWs in any particular tool. I
released templates for loading Sybase IWS in DataStage and Informatica
and got absolutely no interest in them at all...which surprised me....
The advanced C++/ODBC current version of our software that runs across
a variety of platforms, is not free so it's not published...;-) Though
I have published a lot of the source code for the free utilities my
company has released.....email me if you want the address of our
company. my personal email is peter@.peternolan.com. I don't want to be
putting my company address here...to much like advertising and I don't
want to do that here...
You might not believe this, but I believe there is still more cobol
code out there than C++/Java/VB etc put together.....all speaking King
James english... (LOL)!!!
Peter

Help on ETL

Hi,
I'm still new to datawarehousing and right now I'm stuck on ETL. So can
anybody give me some links to a good online resurces about ETL technics.
Thanks,
MariusMarius,
I have publushed the C (and cobol) code you need to emulate to load large
star schema DWs on my personal web page www.peternolan.com. Can't do much
more for free than publish the code you need to emulate..;-)
I have also published a lot of other materials there...
If you are using SQL Server you might want to use DTS.
Best Regards
Peter
"Mark00" <mstoncius@.hotmail.com> wrote in message
news:O%23yTWoydFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I'm still new to datawarehousing and right now I'm stuck on ETL. So can
> anybody give me some links to a good online resurces about ETL technics.
> Thanks,
> Marius
>|||Hello Mark,
Check out the following links. These will help you get started using
DTS as an ETL development platform.
The link below is a great overview of DTS designer
http://www.sqldts.com/default.aspx?278
DTS white papers
DTS programming Techniques Used in Microsoft SQL Server Accelerator for
Business Intelligence
http://msdn.microsoft.com/library/d...
dts_ssabi.asp
Best Practices for Using DTS for Business Intelligence Solutions
(updated web version)
http://msdn.microsoft.com/library/d...ntbpwithdts.asp
Hope this helps
Myles Matheson
Data Warehouse Architect|||C and COBOL? Are the comments written in King James english?
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:e5%23ano0dFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Marius,
> I have publushed the C (and cobol) code you need to emulate to load large
> star schema DWs on my personal web page www.peternolan.com. Can't do much
> more for free than publish the code you need to emulate..;-)
> I have also published a lot of other materials there...
> If you are using SQL Server you might want to use DTS.
> Best Regards
> Peter
> "Mark00" <mstoncius@.hotmail.com> wrote in message
> news:O%23yTWoydFHA.3808@.TK2MSFTNGP14.phx.gbl...
>|||Hi JT,
That's the 'free' stuff that includes many of the features needed to
build a DW...we used it in many clients in the 90s.....(I've been
doing DWs since 1991 when C++ was a novelty and Java was a long time
from being invented...and cobol was still lingua franka of all
computing....) I published it because I am often asked how to build
the ETL code to load type1/2 dimensions, facts, summaries etc....my
answer was..."here is the code you need to replicate the functionality
of for free." I can't do much more than that for
free...(LOL)....also, because there are so many ETL tools, and they
have collapsed their processing and data structures, it's almost
pointless to publish code that loads DWs in any particular tool. I
released templates for loading Sybase IWS in DataStage and Informatica
and got absolutely no interest in them at all...which surprised me....
The advanced C++/ODBC current version of our software that runs across
a variety of platforms, is not free so it's not published...;-) Though
I have published a lot of the source code for the free utilities my
company has released.....email me if you want the address of our
company. my personal email is peter@.peternolan.com. I don't want to be
putting my company address here...to much like advertising and I don't
want to do that here...
You might not believe this, but I believe there is still more cobol
code out there than C++/Java/VB etc put together.....all speaking King
James english... (LOL)!!!
Peter

Monday, March 12, 2012

Help needed on Full text Search

Hello,
we got a requirement where i hvae to implement a full text search in SQL
Server 2000/2005. Can some one help me Where/How to start ? Any links for
the articles is also good.
Thanks in Advance
Srinivas
have a look at the links in indexserverfaq.com for sql fts.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Srinivas Kollipara" <skollipara@.stratasolutions.com> wrote in message
news:eweiaU9FGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we got a requirement where i hvae to implement a full text search in SQL
> Server 2000/2005. Can some one help me Where/How to start ? Any links for
> the articles is also good.
> Thanks in Advance
> Srinivas
>

Help needed on Full text Search

Hello,
we got a requirement where i hvae to implement a full text search in SQL
Server 2000/2005. Can some one help me Where/How to start ? Any links for
the articles is also good.
Thanks in Advance
Srinivashave a look at the links in indexserverfaq.com for sql fts.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Srinivas Kollipara" <skollipara@.stratasolutions.com> wrote in message
news:eweiaU9FGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we got a requirement where i hvae to implement a full text search in SQL
> Server 2000/2005. Can some one help me Where/How to start ? Any links for
> the articles is also good.
> Thanks in Advance
> Srinivas
>

Help needed on Full text Search

Hello,
we got a requirement where i hvae to implement a full text search in SQL
Server 2000/2005. Can some one help me Where/How to start ? Any links for
the articles is also good.
Thanks in Advance
Srinivashave a look at the links in indexserverfaq.com for sql fts.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Srinivas Kollipara" <skollipara@.stratasolutions.com> wrote in message
news:eweiaU9FGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we got a requirement where i hvae to implement a full text search in SQL
> Server 2000/2005. Can some one help me Where/How to start ? Any links for
> the articles is also good.
> Thanks in Advance
> Srinivas
>