Viewing 15 posts - 376 through 390 (of 2,008 total)
Few pointers: (please evaluate them on test server first)
January 7, 2012 at 6:28 am
The answer can’t be a straight yes/no; it depends on many things. For Example, if you introduce ETL it needs to be in SYNC with rest of the databases (frequency...
January 7, 2012 at 6:21 am
Steve Jones - SSC Editor (1/6/2012)
User posts
SQLRNNR ...
January 7, 2012 at 6:10 am
Guys, it’s an Oracle Data Warehouse and questions are distributed in multiple threads...
http://www.sqlservercentral.com/Forums/Topic1231770-391-1.aspx
http://www.sqlservercentral.com/Forums/Topic1231314-391-1.aspx
January 7, 2012 at 5:03 am
How big is your database (data & log files)? What’s the growth pattern?
January 7, 2012 at 4:43 am
You are repeating your mistake. It’s SQL Server forum. You shouldn’t expect help on Oracle queries here because the syntaxes & data types differ in these two technologies.
Even if somebody...
January 7, 2012 at 4:40 am
Adding few thoughts here:
•Time Dimension is the most difficult dimension (IMO) to populate. Many guys (here) may oppose to me but I have seen long (& boring / interesting sometimes)...
January 7, 2012 at 4:32 am
Delario (1/7/2012)
no the table name is actually called "fact_table". the idea is to insert td1id and td2id into the "fact_table.
What about posting your scripts here? Did you try anything...
January 7, 2012 at 4:06 am
Brandie Tarvin (1/6/2012)
PaulB-TheOneAndOnly (1/6/2012)
Brandie Tarvin (1/6/2012)
Delario (1/6/2012)
sql developer in fact I just copy the syntax, i know that the quataion marks are not allow
It's more than just the quotations. NUMBER...
January 7, 2012 at 4:04 am
It's easier that it appears.
Value = Row_Num * Increment_step
Now whatever the looping logic you prefer, insert it in a loop for 100 records.
January 7, 2012 at 3:54 am
Where are you stuck in Fact Population? Please post your script here, we will debug it if it fails or need improvements.
Also, it’s a Fact-Less-Fact table. Is it the intended...
January 7, 2012 at 3:48 am
If temp table means #table then be aware of their life (limited to session) in the database.
Also, I don’t think it would be any better than regular tables except they...
January 7, 2012 at 2:24 am
Where’s the Fact here? Table1 & Table2 look like Dimension table only.
January 7, 2012 at 2:17 am
--Borrowed from bt ;-)
--condition in where clause
select c.*
from dbo.Content as c
join dbo.Content_MTM_SearchCriteria as csc
on csc.ContentID = c.ContentID -- Foreign Key
where csc.SearchCriteriaID = 597
I prefer individual filters to appear...
January 7, 2012 at 12:56 am
rodto3rd (1/5/2012)
January 5, 2012 at 10:10 am
Viewing 15 posts - 376 through 390 (of 2,008 total)