Type -2 - Effective From Date...Audit field(Update

Reporting against OLTP - urgent

I have a set of reports that are going against OLTP systems since the requirement is for real time data reporting. There is a request to improve performance. Could you suggest ways to do so, data warehouse is not an option. Is ODS better? what are the

Date Dimension or DateTime Field

Hi, I'm working on a project where dimensions have dates in them. An example is for a client where we have date of birth, joining date, date of death, etc. In fact i have about 6 different date columns. Now, I'm trying to find out what the best

Cubes on OLTP

Can we build cubes on top of OLTP systems

Dealing with a terrible OLTP system. Long, but I'd appreciate some expert guidance.

To recap, I am dealing with an OLTP with the following characteristics. It doesn't have any Primary or Foreign Keys and lacks referential integrity. It does have clustered unique indexes created on identity columns in most tables. A majority of the

testing form submission with current time input

Hi, I am using Selenium IDE but couldn't use Selenium RC. when I extract zipfile which I downloaded from http://seleniumhq.org/download/, its giving an error after 80% extraction it seems. That might be a problem. What I wan

selenium.type("id","value"); does not work

Here is my sample code: selenium.open("/test.php"); selenium.waitForPageToLoad("30000"); selenium.type("name","TestName"); selenium.type("description","TestDescription"); selenium.click("OK"); selenium.waitForPageToLoad("30000"); When

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

How to handle date and time in a web page

Hi all, am at beginner level in selenium IDE, very happy to joined in to this forum, please some one answer the following scenarios in Selenium IDE based. My scenarios are : how to handle the following in my webpage: 1. ex(text displayed in

MF0013-Internal Audit and Control-Assignment Set- 1

Summer 2011- May drive Master of Business Administration - MBA Semester 3 Subject Code –MF0013 Subject Name –Internal Audit and Control

Danice123's Dev. Log

Hey guys, I'm Danice123. I'm gonna be working on the power/electronics systems at the moment, but that may change depending on where I'm needed. >------------------------------- -1/8/12 -Wireless Redstone Project -Force Field

Seamaster and Iago's endless rehashing Bond thread

I assume that you read about this: http://www.avclub.com/articles/javier-bardem-will-be-the-new-bond-villain,63238/

Oh my god introduce us!!

This is where you introduce yourselves and share any detail about yourself that you think we'd like to know. Nothing TMI though... jk 8D I guess I should start first. My name is Tina and I'm Chandler's ~querida~.

Type -2 - Effective From Date...Audit field(Update_TS) from OLTP or System Time ?