Senior Data Architect /Data Warehouse / Business Intelligence
Skill and Knowledge Profile If you are inquisitive, self-demanding, and ambitious... If you live, breathe, and love data and behavioral analytics... If building and growing an early stage company is in your career plan... If you have an excellent

Database kdb ?
Is anyone using a database by name kdb ? If so, do u use informatica with it ? - Thanks, bi_at_nj

Should a data warehouse be the reporting database?
I have developed a data warehouse for our company that includes an accumulating snapshot for an application process very similar to Chapter 12, "Education" in "The Data Warehouse Toolkit" (Second Edition). The intention was to create BI on the pipeline,

Best Practice Database Schema/user layout
Just wanted to check to see how others have structured the typical data warehouse schema layout. I know much of this is based on the individual project requirments, but I just wanted to see how others have done it. I was thinking about the following

Database by name KDB ?
Is anyone using a database by name KDB ? What are your comments on it ? What ETL tool are you using with it ? Infa? (using ODBC driver? do they have odbc driver for this? ) Please specify. Thanks, bi_at_nj

Schemas ... in the final dimensional models (BI database)
Hi quick question ... We are planning to have 2 or three staging databases. 1) Staging 2) Conforming and then finally the actuall BI database 3) DataWarehouse My question, in this final final database (3) should we use schemas to 'group

Dimension Attributes and Fact attributes storing same data in multiple data marts??
Can data marts using BUS architecture store the same data but be called different names like DimChargeToDept and DimDepartment. All have the same attirbutes names different but same exact data and rows. I would rather they create a view for each

Clean Database
When I finish watching an episode of a TV Show in XBMC, I sometimes delete it from the library. It will then ask if I also want to delete the video file, which I do. However, Media Companion still picks up the nfo (which was not deleted by XBMC) and

Forum Database Backup
Hello, I would like to request a backup of my forum's database, as some insurance in case something goes wrong (given the current forum's size). Also, I would like to try out how it would work in a phpBB enviroment, so I would also need some advice/help

Start schema in relational database vs OLAP
I understand what OLAP and MOLAP are and their purpose in theory. Under what scenarios would one consider switching from start schemas in relational database to OLAP technology and building cubes? I understand this is more frequent in financial

Business keys in Fact. Is this accepted?
It is a data warehouse optimization project and a very basic data warehouse is in place. There are a couple of dimensions with only 2, 3 columns only (<30 rows) and where the Business key can be easily interpreted. Ex: Event_Type_DIM: this has 2

Business Rule Development
Looking for comments regarding structured business rule development and maintenance. Has anyone used commercial applications or used data mining techniques in extracting business rules from legacy systems.

selenium with database testing
Hi, Can any one tell me how to test database with selenium as i am testing java application, pls give me some links or some examples as i am new to this testing,waiting for your quick reply.

Reporting tool knowledge
I’m finding myself in a situation where my knowledge of the organization’s BI/reporting tools are highly restricted. So, I’m just taking survey, how knowledgeable of an organization’s BI and reporting tools should the tools’ EDW modeler be?

Business Objects with Multiple Facts and Contexts
We are finally using a dimensional model for reporting on a widespread basis. These universes have multiple fact tables. These fact tables have shared dimensions. Unfortunately, we have users now creating reports without pulling measures that would