Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Can I have more than one date dimension

This is a discussion on Can I have more than one date dimension within the Data Warehousing forums, part of the Databases category; Can I have more than one date dimension and if I want to include more than one date in my project, How do I construct my fact table. i.e, ...

Geeks Talk > Databases > Data Warehousing Can I have more than one date dimension

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   06-16-2007

Geek_Guest Expert Member   Join Date: Feb 2007 Posts: 1,279 Thanks: 0 Thanked 164 Times in 138 Posts

Can I have more than one date dimension Can I have more than one date dimension and if I want to include more than one date in my project, How do I construct my fact table. i.e, Suppose I want sanction_date and fund_date in my project, How do I include them at one point of time? Question asked by visitor jayalakshmi

Sponsored Links

#2 (permalink)   06-27-2007

emsrinivas Junior Member   Join Date: Jun 2007 Location: hyderabad Posts: 6 Thanks: 1 Thanked 0 Times in 0 Posts

Re: Can I have more than one date dimension exactly I am not getting what you are telling but dam sure I can say that if you have some thing like 2 dates then why don't you make aliase one is sanction_date and other one is fund_date......

Geeks Talk > Databases > Data Warehousing

« Overlapping in businss objectss reporter | Operational database vs data warehouse »

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
Testcases for Date	bharathi_ark	Test Cases	2	06-20-2007 09:06 AM
Type 2 slowly changing dimension with version numbers	mzladyd	Data Warehousing	0	06-07-2007 02:16 PM
Macros in Report and Creating Measure Dimension	Geek_Guest	Data Warehousing	0	04-30-2007 03:12 PM
romise date, Need by date, Original Date in PO	Geek_Guest	Oracle Apps	0	04-07-2007 12:53 AM
release date	Aam23	LoadRunner	1	01-28-2007 03:18 PM

All times are GMT -4. The time now is 01:19 PM.