.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Archtectural components of a data warehouse

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server
Architectural components, infrastructure: Operational and Physical, Extraction, Transformation and Loading, components of an Oracle data warehouse, Data Transformation Functions, DBA responsibilities,Capacity planning  

View Complete Post

More Related Resource Links

What does strategy exist to deploy SSIS package and my own data flow components into a enterparise s

I created a SSIS package and several data flow componenets for this package.    What does strategy exist to deploy SSIS package and data flow components into a enterparise server?   Thanks in advance.

What are the technical issues would you expect to face when building a centralised data warehouse fo

Hi, I am new to data warehousing and recently I was asked this question  which I did not know the answer. I would be grateful if someone kindly help me with the answer or direqt me to a link.   Q.  What are the technical issues would you expect to face when building a centralised data warehouse for reporting purposes?

Trying to find out how data from warehouse is loaded into a dimension


(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. 



Explain Data warehouse maintainence


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.

erratic performance with data warehouse query...


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

SQL Server 2008 Management Data Warehouse - Remote Upload Fails

I recently set up the Management Data Warehouse and have encountered an issue with one of the jobs failing.  I set up the database, which I called MgmtDataWhse on a central server, SQL35.  I set up collection on that server and it seems to work fine.  I set up collection on a different server, SQL30, and pointed it to the database on SQL35.  On SQL30, 2 of the 3 collection/upload tasks work fine.  The MDW - collection_set_3_upload job fails on the collection_set_3_upload_upload step, with little useful output. 


These are both clustered servers.  I've looked at the SSIS packages on SQL35, specifically the QueryActivityUpload package, but wasn't able to determine what the issue might be.  For some reason, I can't look at the stored packages on SQL30 in SSMS.  Do anyone have any ideas on how to troubleshoot this issue? 

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

Dynamic Data Templates in GridView ASP.NET 3.5

At a high level, Dynamic Data Templates can be seen as a system to very quickly build up a User Interface linked with the relevant data model, immediately enabling you to perform CRUD operations (Create, Read, Update, Delete) on the database using the specified data source. They provide a powerful method for building up these kinds of applications, and I'm going to focus on an overview of what Dynamic Data Templates actually are, and a few ways of customizing them to suit industry needs.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Displaying Data using ASP.NET 2.0 Repeater and C#

This tutorial will show you how to display data using the .NET Repeater Control, ASP.NET 2.0 and C#.NET

The Repeater control is a powerful tool and is easy to use.

First, you will need to import the System.Data.SqlClient namespace.

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

ASP.NET 4.0 Dynamic Data and Many to Many Entity Framework Entities

I did not play much with Dynamic Data controls in VS2008 and just made a cool discovery in VS2010 Beta 2. This may not even be new, but as I'm sitting 30,000+ feet over the Atlantic ocean, I don't have access to VS2008 at the moment to check.

Display data in gridview dynamicallay

I have AD domain which has 100000 users, I want to display all the users in gridview controls.Actually it is displaying users in gridview after parsing entire domain which takes around 30 min. I want to display the users while loading itself.It is continously getting user information from AD domain and getting each user details, I want to display the users information which already queried instead of waiting till getting all users information
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend