Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Loading data into fact table

2 posters

Go down

Loading data into fact table Empty Loading data into fact table

Post  dwnewbie Sun Jan 20, 2013 4:33 pm

I'm trying to create and populate three dimensions and a fact tables with data. The dimensions work just fine but i'm unable to get any data into my fact table. If anyone will be so kind to point out what i'm doing wrong - i will be grateful.

Thank you all very much.

This is my code

[create table Customer
(
CUID integer identity(1,1) primary key,
Name varchar (25)
)
insert into Customer select distinct customer from [Data]

create table Agent
(
AID integer identity(1,1) primary key,
Agent varchar (25)
)
insert into Agent select distinct Seller from [Data]

create table Time
(
TID integer identity(1,1) primary key,
Week varchar (25),
Month varchar (25),
Year int
)
insert into Time
(Week,Month,Year)
select distinct Day,Month,Year from [Data]

Create Table Fact
(
CUID integer,
AID integer,
TID integer,
Sale money,
constraint pk_Fact primary key (CUID, AID, TID),
constraint fk1_Fact foreign key (CUID)
references Customer (CUID),
constraint fk2_Fact foreign key (AID)
references Agent (AID),
constraint fk3_Fact foreign key (TID)
references Time (TID),
)
insert into Fact
(CUID, AID, TID, Sale)
SELECT CUID, AID, TID, Sale
FROM Customer,
Agent,
Time,
[Data]]

dwnewbie

Posts : 2
Join date : 2013-01-20

Back to top Go down

Loading data into fact table Empty Re:Loading data into fact table

Post  hkandpal Sun Jan 20, 2013 5:31 pm

Hi,

you have foreign key constraint on the fact tables to other dimension tables, when trying to insert into the fact are you getting a foreign key voilations.

thanks

Himanshu

hkandpal

Posts : 113
Join date : 2010-08-16

Back to top Go down

Loading data into fact table Empty Re: Loading data into fact table

Post  dwnewbie Sun Jan 20, 2013 7:54 pm

hkandpal wrote:Hi,

you have foreign key constraint on the fact tables to other dimension tables, when trying to insert into the fact are you getting a foreign key voilations.

thanks

Himanshu

Yes i am. What did i do wrong?

dwnewbie

Posts : 2
Join date : 2013-01-20

Back to top Go down

Loading data into fact table Empty Re: Loading data into fact table

Post  hkandpal Thu Jan 24, 2013 9:03 am

If you are getting a FK voilation error then, it looks live those dim values are not present in your dimension table, check if your load dimension process is happening correctly.

thanks

Himanshu

hkandpal

Posts : 113
Join date : 2010-08-16

Back to top Go down

Loading data into fact table Empty Re: Loading data into fact table

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum