Need some assistance.

[variant01]

Hi,

I am new to data warehousing and have a question. Lets say I have a OLTP structure like the one below.

tblSession

Session_id
application_type_id
source1
target1
source2
target2
source_entity
target_entity

And we want to summarize BY application_type or BY source1 or BY target1 etc. How would I approach this problem in regards to a data warehouse design? Furthermore, does it make since to use a dataware for these types of facts?

Thanks.

 

[Subhashab]

I cannot figure out the grain of the information, in order words the primary key of the above table.

such table are called factless table in DW

such fact table with contain one dummy column called as Count and will have 1 as the values for each row. When you add these one across application_type or session u will get the number of transcation summarized for that type.

please let me know the primary key of the session table and the type of information you are trying to analyze in the DW. this will help me to give u guideline for the table design