Extracting - separate source tables vs SQL query

[QUERY] How to separate Important, and Pinned Topics from Normal Topics with a table?

http://spambots.ace.st I forgot how to do this feature, but can someone please tell me how to separate Important and Pinned Topics from Normal Topics by a table? Just like our forums here.

Data Warehouse spread across 4 separate databases

Hello, I started with a new BI team. Our data warehouse was developed by consultants. I find the design very strange, but they insist that it uses BI best practices. I can't find any best practices supporting this set-up. Can anyone help me

Extracting data when there is no timestamp in the source system

Guys, what are your strategies to extract data when the source system does not have any timestamps. Is there any way to still get deltas ? Thanks

How to create transactions SCD2 from many SCD tables

Hello, During the design of a HR data mart I had a problem that was repeated in every dimension: All the dimensions are SCD type 2 and their sources are few operational tables that each table has a history records. For example: Dim Employee is buil

Handling fact tables with different grain in Business Objects

Hi, i'm new to BI and Business Objects tools in particular. We have a fairly simple "Sales" datamodel - only 4 stars. the problem we're facing is the "SalesPlan" data. "SalesPlan" is defined on two different levels and more

Save to xml instead of separate nfo files

This program is really handy, but I cannot use it on some of my read-only shares for obvious reasons. I would really like the option to write the contents of what would be individual nfo files scattered about into one large xml file that I can save

Natural resources in the Kurdistan region says it covering the salaries of extracting crude oil from fields

Natural resources in the Kurdistan region says it covering the salaries of extracting crude oil from fields Editor: NK | SS | SA Wednesday, 11 August 2010 10:03 GMT Alsumaria News / Erbil The Ministry of natural resources in the Kurdistan

Deleting Topic/Attachments Separate

Many will notice how in permissions per category youll see Delete its own messages and Attachments. Id like to suggest we make this 2 separate things. To be able to allow members to delete attachments but not their posts. This will help the MODS out no

Separate column for moderator names

Now moderator names are displaying below forum forum names in this format: Forum name Moderator: Username I'm suggesting to add separate column on index page for moderator names, (like topic and post numbers or Last Post). This will abridge the

OPEN SOURCE CHARACTERS PUBLISHED BY M.K.U.I.I.

UNCLE-SAM OZ DOROTHY GALE TWISTED TIN-MAN OZMA THE BEAST BEAUTY TARZAN Open Source Characters are characters created specifically for, or later made available for, use by anyone. The main difference between "Open

Announcements and Sticky topics in seperate tables!

Yep, according to the topic /other-problems-f46/possible-t76511.htm it isn't possible to split global announcements and stickies in a seperate table. I'm suggesting for this to be possible! I hate it when the forums are so messed up! I'm sure the

Dimension loading sources

Hi all, It's about datawarehouse dimension loading : should i load dimension from a master data management referential or from the truth of my business application. In the first case, dimension will be cleaner than in the second case but it will not

simbro - test for "take a walk" function

please bear with me as this is my first attempt at releasing a version I have implemented a test for the "take a walk" function in the "manage" window. It has no effect on the game so far, it is just to see if it is working