Home » SQL & PL/SQL » SQL & PL/SQL » SCD Via Stored Procedures in Oracle (Oracle 10g / unix / windows)
SCD Via Stored Procedures in Oracle [message #381004] Wed, 14 January 2009 14:59 Go to next message
thskumaru
Messages: 4
Registered: January 2009
Location: New Jersey
Junior Member

Hi All,
Can anyone help me out in writing a stored procedure which implements SCD Type 1 SCD Type 2 SCD Type 3 Dimensions whether to write a Cursor , Stored Procedure ....

If any one can give a sample code that will be of great help . Help will be really appreciated Thanks in advance Ths
Re: SCD Via Stored Procedures in Oracle [message #381005 is a reply to message #381004] Wed, 14 January 2009 15:00 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Too bad GOOGLE is broken for you.
Please be patient while it is repaired.

[Updated on: Wed, 14 January 2009 15:04]

Report message to a moderator

Re: SCD Via Stored Procedures in Oracle [message #381006 is a reply to message #381005] Wed, 14 January 2009 15:02 Go to previous messageGo to next message
thskumaru
Messages: 4
Registered: January 2009
Location: New Jersey
Junior Member

Slowly Changing Dimensions

Type 1 Dim
Type 2 Dim
Type 3 Dim
Re: SCD Via Stored Procedures in Oracle [message #381007 is a reply to message #381005] Wed, 14 January 2009 15:05 Go to previous messageGo to next message
thskumaru
Messages: 4
Registered: January 2009
Location: New Jersey
Junior Member

I Know

Thanks for the update
Re: SCD Via Stored Procedures in Oracle [message #381008 is a reply to message #381004] Wed, 14 January 2009 15:06 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.geekinterview.com/question_details/17228
Re: SCD Via Stored Procedures in Oracle [message #381009 is a reply to message #381008] Wed, 14 January 2009 15:07 Go to previous messageGo to next message
thskumaru
Messages: 4
Registered: January 2009
Location: New Jersey
Junior Member

I know the definations ..how it stores ..
but it would be of great help if any one can help me out how to implement using stored procedures
Re: SCD Via Stored Procedures in Oracle [message #381010 is a reply to message #381004] Wed, 14 January 2009 15:13 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>but it would be of great help if any one can help me out how to implement using stored procedures
It is a Small Matter Of Programming (SMOP)!
You do know how to program, don't you?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

We are not here to do your job/homework for you.

Previous Topic: ora-01440
Next Topic: normalization question need for nullable column ?
Goto Forum:
  


Current Time: Thu Dec 08 00:31:01 CST 2016

Total time taken to generate the page: 0.16221 seconds