View Complete Post
(SQL Server 2005)
I have a customer data warehouse table that I am loading into a customer dimension. Each row in the warehouse has a unique integer key. It is possible to have multiple rows with the same customer name. Each row will have an account code
and an alternate account code. Besides the key field, Name + Account + Alternate is what makes a row unique.
Once I process the table into the warehouse it looks like I am only getting one entry in the dimension based on customer name. It is difficult to browse dimensions and tell exactly what is there. I've tried setting up a plain demision and
also adding Account code and Alternate account codes as attribute relations under Name. I've also tried a hierarchy with Name -> Account -> Alt Account.
I have a customer with 2 account codes and multiple Alternate codes - 29 rows in the warehouse. When I browse I only get one result for name - I want to see 29 names all the same. Do I need to set up the dimension somehow to use Name+Account+Alternate
as the key? Currently I am using the warehouse key field as the key.
Implementation of Data warehouse,Physical design: steps,considerations,physical storage,indexing,Performence Optimization,Data warehouse deployment activities, Data security, backup and recoveryconcepts, Data warehouse maintainence.
Ok I am running into some very strange performance issues with this one particular query.
FROM Enrollment.Processing.Enrollment_Audit a
INNER JOIN Enrollment.Dim.EquipmentType n ON n.EquipmentType = a.Equip_Type
INNER JOIN Enrollment.Dim.ClientID t ON t.Client_ID = 214
INNER JOIN Enrollment.Dim.DealerCode q ON q.Client_ID = 214 AND q.DealerCode = a.DealerCode AND q.EndDate IS NULL
INNER JOIN Enrollment.Dim.DealerCode u ON u.Client_ID = 214 AND u.DealerCode = a.PurchDealerCode AND u.EndDate IS NULL
INNER JOIN Enrollment.Dim.Device i ON i.Client_ID = 214
AND i.Make = a.PMake AND i.Model = a.Pmodel AND i.ClientMarket_ID = a.ClientMarket_Id AND i.EquipmentTypeKey = n.ID
INNER JOIN Enrollment.Dim.ExtendedDevice d ON d.Client_ID = 214
AND d.Device_ID = a.Device_ID AND d.ESN = a.ESN AND d.Mobile_IDN = a.Mobile_IDN
INNER JOIN Enrollment.Dim.Market l ON l.Client_ID = 214 AND l.Market_Code = a.Market_Code
INNER JOIN Enrollment.Dim.Source o ON o.
I'mÃÂ making warehouse for our HMIS (healthcare management information system)by using SSIS. I'm facing some problems now, could you please help me to solve my problem.
Brief idea about my Warehouse:
ÃÂ Source: oracle 9i
ÃÂ Destination: Sql server 2005
ÃÂ ETL tool: SSIS