Require comprehensive test cases for SCD Type2

abhijit.singh2 at 11h37
21
Jun
2010
Require comprehensive test cases for SCD Type2

Hi, I have written the following code in Oracle for SCD Type2. SCD2 table name is employee_tgt and source table is employee_src. It maintains history of column emp_name. The primary key is emp_id and the surrogate key is emp_sk. The load is assumed to run daily.

I wish to use it as template for any dimension of Type2. However, I require someone to provide me with a comprehensive test data set so that I be sure that the code

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
How to propagate variable between tests inside a test suite in Selenium RC
Hi, I am using Selenium RC with HTMLSuite. My test suite is built with a first test, that gets initial values calling webservice and stores them in variables, then a list of tests. My question is how I can access to store variables of the first test
To get a Testing report
Hi, I am very new to use selenium tool. May be it's a silly question. After recording, when I play the test, how do I get the report of the test (Like pass, fail or issues) Thanks in advance
Prototype Project Schedule for BI Project
Hi All: I just wanted to send a quick note to ask if any of the users here had an example of a Project Schedule for a BI Project. I am generally curious about rules of thumb for things like validation, testing, launch, training, etc. Many
Space savings in Star Vs 3NF
I was curious if anybody had any estimates of the savings in space between a 3NF database and the same Data in a Star Schema? If a 3NF database took up 2.5TB, would the Star be 1.25TB? I was just wondering if there was a rule of thumb about it. In
How to use Selenium IDE with tabular data and pagination?
Hi I used to record tests ion selenium IDE for after export in selenium/rspec formt to run all them with Selenium RC. Now, I aquire a doubt when I was recording some test of crude operation of data in table with pagination. For example, supose that
Forums from same category
See also
more_less
Informations

0 Replies For the topic :
"Require comprehensive test cases for SCD Type2"

This topic has been viewed 1060 times.

Last message :
21/06/2010 at 11h37 by "abhijit.singh2"