Results 1 for
"conformed dimensions kimball"
Data Marts, Conformed dimensions and Data Warehouse
Hello, Can you please assist me in understanding the following. I am new to data warehouse. I'm using microsoft products to build my enterprise DW/BI 1. Do I build data marts for my enterprise DW/BI or do I iteratively build a data warehouse? I
Hello, Can you please assist me in understanding the following. I am new to data warehouse. I'm using microsoft products to build my enterprise DW/BI 1. Do I build data marts for my enterprise DW/BI or do I iteratively build a data warehouse? I
Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
I'm working on a new warehouse application for reporting against our IT Project database. I want to create both a transaction fact table and an accumulating snapshot fact table. The project database (source) consists of multiple normalized tables to
I'm working on a new warehouse application for reporting against our IT Project database. I want to create both a transaction fact table and an accumulating snapshot fact table. The project database (source) consists of multiple normalized tables to
Conformed Dimension Processing Multiple Data Marts
Rookie question. We have 8 conformed dimensions and we are on our 4th data mart using some of these 8 conformed dimensions. We build the conformed dimensions once every night because the client wants to complete full refresh only. The client has
Rookie question. We have 8 conformed dimensions and we are on our 4th data mart using some of these 8 conformed dimensions. We build the conformed dimensions once every night because the client wants to complete full refresh only. The client has
Multivalued Dimension or Multiple facts w/conformed dimensions
I am trying to model for insurance industry, with data as follows: We have data at different levels: Policy level with related facts. ((Premium , face amount, mode etc) Policy Fund level (combination with related fact values.) Policy Rider level
I am trying to model for insurance industry, with data as follows: We have data at different levels: Policy level with related facts. ((Premium , face amount, mode etc) Policy Fund level (combination with related fact values.) Policy Rider level
Bus Matrix in SAP suite
Has anyone implemented the BUS Matrix using the SAP suite? I got a customer where SAP is their core BI element at the moment, so I would like to know any tips about how to implement the BUS Matrix in SAP BI suite Thanks, kpsota
Has anyone implemented the BUS Matrix using the SAP suite? I got a customer where SAP is their core BI element at the moment, so I would like to know any tips about how to implement the BUS Matrix in SAP BI suite Thanks, kpsota
How to manage Conformed dimensions
Hi, If I'm implementing data mart by data mart, I build a dimension for the first data mart. After a few months, I realize I can use that dimension for the second data mart as a conformed dimension. But it needs additional columns. How do you manage this
Hi, If I'm implementing data mart by data mart, I build a dimension for the first data mart. After a few months, I realize I can use that dimension for the second data mart as a conformed dimension. But it needs additional columns. How do you manage this
Conforming Dimensions - Standardising, De-duplicating and Suvivorship
Hi, I'm currently reading the DW ETL toolkit, which seems to have some excellent ideas. However, as it doesn't come with any downloads (e.g example SSIS packages) - I'm struggling to understand a few things. If anyone can answer the following it would
Hi, I'm currently reading the DW ETL toolkit, which seems to have some excellent ideas. However, as it doesn't come with any downloads (e.g example SSIS packages) - I'm struggling to understand a few things. If anyone can answer the following it would
Kimball Dimensions
I got into a nice heated debate the other day. The item of discussion was flattened dimensions. Id like to know your opinion (or facts) about the following, (Some of this is common sense please still give me some feedback ). Any article citations
I got into a nice heated debate the other day. The item of discussion was flattened dimensions. Id like to know your opinion (or facts) about the following, (Some of this is common sense please still give me some feedback ). Any article citations
Monster Dimensions
My customer list is huge (about 70 millionish). We currently have a 60 million row dimension (CUSTOMER) that holds most of our existing customers, and this existing large DIM is currently performing fine for us. Now my clients want to type 2 two
My customer list is huge (about 70 millionish). We currently have a 60 million row dimension (CUSTOMER) that holds most of our existing customers, and this existing large DIM is currently performing fine for us. Now my clients want to type 2 two
Conformed Dimension Partial Set of Attributes
Hi Just looking for some confirmation that a dimension with partial attributes might still be considered conformed. For eample A dimension of batch ProdBatch PK BatchID Batch Name Product ID Product Name ... at an invoice Fact table
Hi Just looking for some confirmation that a dimension with partial attributes might still be considered conformed. For eample A dimension of batch ProdBatch PK BatchID Batch Name Product ID Product Name ... at an invoice Fact table
Mini Dimensions
Hi In out data warehouse design (superannuation) we need to cater for Client and Accounts and the relationship between them (a client can have one or more accounts). Some of the client attributes can change so we were thinking or having a client
Hi In out data warehouse design (superannuation) we need to cater for Client and Accounts and the relationship between them (a client can have one or more accounts). Some of the client attributes can change so we were thinking or having a client
Dates in many dimensions
Hello, I am new to DW. Currently, I am working on a Human Resource database. There are many tables in the source systems which stores dates e.g. dates about contract start, finish, Vacations of an employee, temporary service suspension and many more.
Hello, I am new to DW. Currently, I am working on a Human Resource database. There are many tables in the source systems which stores dates e.g. dates about contract start, finish, Vacations of an employee, temporary service suspension and many more.
Sparse dimensions, how to handle?
I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl
I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl
Junk Dimension Naming
What do you call your junk dimensions? Do you use "junk" in the dimension name? Junk implies garbage so I don't like using it. Most dimensions are easily named since they represent a single person, place, thing, concept, or event. Junk
What do you call your junk dimensions? Do you use "junk" in the dimension name? Junk implies garbage so I don't like using it. Most dimensions are easily named since they represent a single person, place, thing, concept, or event. Junk
Degenerate Dimensions
Hi there, I have come across a situation where my Fact table contains a degenerate 'Claim Number' column. This is fine, but I have discovered that some of the incoming data to populate my fact table do not have a claim number. How should I handle this
Hi there, I have come across a situation where my Fact table contains a degenerate 'Claim Number' column. This is fine, but I have discovered that some of the incoming data to populate my fact table do not have a claim number. How should I handle this
Results 1 to 15 on 327
for "conformed dimensions kimball"
for "conformed dimensions kimball"
Active topics
Popular topics
Unanswered topics
