Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
For each value in one table, select nearest value in another table
This is pretty simple to describe: Table A & B both have a date field. I need a query/procedure which will do: SELECT A.date, { max(B.date) where B.date < A.date} Example: A.date.... B.date ======.... ====== 10/10/2006 01/01/1999 01/04/2007 12/12/2006 Result: A.date | Max B.date < A.date...- d000hg
- Thread
- Replies: 1
- Forum: Data Warehousing/Big Data
-
Table acting as dimension and fact - ugly.
Imagine you want to load to a DW something like the number of minutes spent by a person on a project. The obvious interpretation is that the measurable fact is the number of minutes, and the person and the project should be the dimensions. But what if you also need to load the projects into the...- d000hg
- Thread
- Replies: 8
- Forum: Data Warehousing/Big Data
-
A couple of questions about populating a Data Warehouse
Hi there. I'm new here so if my questions are already answered please let me know. Anyway, two questions about loading data into a DW from the operational process databases: 1)Do we normally update the DW each time the operational DBs are modified? i.e when a sale is made would the DW be...- d000hg
- Thread
- Replies: 4
- Forum: Data Warehousing/Big Data
