|
|
-
|
|
Read this article:
......
|
|
-
|
|
What Is Master Data?
Most software systems have lists of data that are shared and used by several of the applications that make up the system. For example, a typical ERP system as a minimum will have a Customer Master, an Item Master, and an Account Master. This master data is often one of the key ......
|
|
-
|
|
Large companies face challenges from emphasis on regulatory compliance, such as software license compliance (not mention the auditing pressure from internal organization and external vendors), consistent reporting, and mergers and acquisitions, it has made the creating and maintaining of accurate an......
|
|
-
|
|
Installation
1. Download Visual Studio 2005 Team Foundation Server Workgroup Edition from MSDN.
2. Extract All Objects from ISOBuster
3. Run autorun.exe from the installation folder. Select Install Team Explorer. The product key is pre-built.
Setup
4. Open VS 2005. Under Tool, ther......
|
|
-
|
|
Here is an article from www.SearchSQLServer.com:
http://viewer.media.bitpipe.com/1216309501_94/1268760175_892/Master-Data-Management-Projects-in-Practice_An-Information-Difference-Research-Study.pdf......
|
|
-
|
|
Here is what Wikipedia (http://en.wikipedia.org/wiki/Master_Data_Management) defines Master Data Management:
In computing, master data management (MDM) comprises a set of processes and tools that consistently defines and manages the non-transactional data entities of an organization (which may incl......
|
|
-
|
|
Here is a very good Data Modeling 101 article, http://www.agiledata.org/essays/dataModeling101.html. I agree with the author that every IT professional, including application developers, database developers, data analyst, database administrators, should have some basic understanding of data modeling......
|
|
-
|
|
Here are some SSIS related Interview Questions with answers.
1. What is the control flow
Answer: In SSIS a workflow is called a control-flow. A control-flow links together our modular data-flows as a series of operations in order to achieve a desired result.
A control flow consists of one or mor......
|
|
-
|
|
Each point in a multidimensional space is defined by a collection of coordinates – a tuple, while each coordinate corresponds to a dimension member. A simple tuple contains two members would be ([2010], [USA]). The simplest way (not the best) to reference a member in MDX is to enclose its name......
|
|
-
|
|
There are many BI client tools out there, ProClarity Desktop Designer, Excel, Corda, Sharepoint Server BI dashboard, and even Microsoft SQL Server management studio. But as a BI developer, it’s still very important to be able to write basic MDX queries.
I use Microsoft SQL Server management s......
|
|