Data Warehousing Community Forum
August 22, 2019, 11:03:13 pm

Pages: [1]   Go Down
  Print  
Author Topic: star schema database in sql server  (Read 6907 times)
bakhtawar
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 2


View Profile
« on: November 09, 2014, 12:31:29 am »


I create a test1 database in sql server 2008 r2 and then another test 2 db ..

tables
product_info table
Product_id
product_name
unitprice
unitsonorder

user_info table
user_id
user_name
user_pwd
email
city
product_id

and in test 2 db i create star schema erd is image


now here i want to select data from test1 db and then execute in test2 db .. like etl.. extract, transform and load...

so how i done this?
Logged
Pages: [1]   Go Up
  Print  
Jump to: