Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Populating Date Time Dimension

This is a discussion on Populating Date Time Dimension within the Data Warehousing forums, part of the Databases category; I have to popluate a date time dimesion with all the days of three years (2005,2006,2007) without using stored procedures in Oracle.. is there any way to go ...

Geeks Talk > Databases > Data Warehousing Populating Date Time Dimension

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   02-06-2008

madhurikharidas Junior Member   Join Date: Feb 2008 Location: INDIA Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Populating Date Time Dimension I have to popluate a date time dimesion with all the days of three years (2005,2006,2007) without using stored procedures in Oracle.. is there any way to go about that?

Sponsored Links

#2 (permalink)   02-06-2008

deviji2000 Junior Member   Join Date: Jul 2007 Location: India Posts: 7 Thanks: 0 Thanked 1 Time in 1 Post

Re: Populating Date Time Dimension be brief about what you have tried, so that we can give you some solution. -viji

#3 (permalink)   02-06-2008

suresh_oracle9i Junior Member   Join Date: Feb 2006 Posts: 2 Thanks: 1 Thanked 0 Times in 0 Posts

Re: Populating Date Time Dimension U can try with expressions using date function instead using oracle SP.

Geeks Talk > Databases > Data Warehousing

« Mutliple sources file list continue on error | Tools related to Datawarehousing »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hire date and salary review date	Geek_Guest	SQL	4	10-20-2008 05:35 AM
Populating List in forms 6i	krishnaindia2007	Oracle	0	09-24-2007 05:39 AM
Testcases for Date/time/year	surender_gupta1	Test Cases	2	08-06-2007 02:36 AM
Can I have more than one date dimension	Geek_Guest	Data Warehousing	1	06-27-2007 03:51 PM
romise date, Need by date, Original Date in PO	Geek_Guest	Oracle Apps	0	04-07-2007 12:53 AM

All times are GMT -4. The time now is 08:39 PM.