Converting Columns into Rows.
I have a requirement where I need to convert rows in columns. The data is quite huge there would be around 200 million records. The sample table contains only data for five months but in actual 12 months of data come in a single row and number of columns

Loading Future Dated Rows to Dimensions
Hi All, Our OLTP system supports effective dated concept. So users can enter Future Dated Rows also. And in our Warehouse we have both Type1 Dimesnions and Type2 Dimensions. When loading the data to Type1 dimesnions, if we load future dated row

Large Dimension table compared to fact table?
I may be misguided in my attempt to make a dimensional model here, but I will explain the scenario. We provide a value add service in the supply chain business...in this case by depicting a scorecard of the accuracy of vendors' product sizing

difference between alias and duplicate tables in OBIEE
Tell me about these alias and duplicate tables in repository of obiee and how they differ from one another and when we work on these tables

Subscription as an Accumulating Snapshot Fact or a Dimension?
I am designing a data mart for a subscription based service (my first data modelling effort). Each customer can have multiple accounts and each account can have multiple subscriptions. I have added a Sales Fact table and a Monthly Subscription Snaphot

[1.986] Duplicate movie found in new scans
Just cranked it up and hit go, and this is the result. Will do some more testing. Starting Folder Scan 8 New Movies Found Searching IMDB For The Devil's Advocate (1997) IMDB ID found :- tt0118971 nfo saved as :-

Preserving prior history for late arriving dimensions
Can't find much about this topic anywhere else so hopefully someone can help me. Our warehouse has late arriving dimensions for an Employee. Their department changes, for example, can be backdated in the systems and so we have to account for this and

3.182 - TV Show Scrapes Duplicate Episodes for IFO Container
I just started adding my TV shows, and noticed that when I rip the full disc in the IFO container (so there are multiple files for the disc), MC scrapes the show and then creates an .nfo file for every .VOB file in the folder and for the Video_TS.ifo

NULL Values in Fact Table
In an Accumulating Snapshot that has multiple dates, where we are revisiting the fact rows as additional events occur, should the foreign keys to the date dimension for dates that have not yet occurred be set to NULL or should they point to a

Check for duplicate episodes and delete the older file
I have a problem sometimes where I will get an episode, and then a proper for that episode will be released and my rss feed will download it again. Normally I would just use a filter to get rid of everything that I don't want, however i would like to

Single Release ? - Neat Little Rows
Just wondering what the first single off the Album will be Is Lippy kids just a taster for us, or is that intended to be a release ? If it's going to be another track, surely we'd have to get wind of that soon, assuming any release would probably be

Dealing with Snow
I am consider myself a Green person I don't use Gas products to take care of the yard in the summer. In the winter it's the same. But my Snow Joe shovel blades are broken again. This time can't find the part and the device is so heavy to lift. So okay tim

How long should -1 dummy records exist in fact tables?
Dear Kimball Group, we are using the Kimball BUS Architecture method with SQL Server 2005, SSIS, SSAS, ProClarity, PPS, and MOSS. I am at a clients site that is using Full Refresh process for building 3 data marts so far every night. We are trying to

DUPLICATE OR UNWANTED MOVIE INFO
I have some duplicate and incorrect titles showing in the left title pane, i can i delete these permanently ? Also have to mention the fantastic work that has been done by the creator. I had downloaded and installed another program but once i had MC

data model for 2 fact tables (Header / Detail scenario)
Hello, I want to verify that I have this data model correct to present as the high level design. Requirement: 2 facts to be available in one cube. Facts must be separate physically (regulatory) and it is a header / detail scenario so we do not want