-
Re-engineering of Organization
What is Re-engineering of an organization?
idanh79
- Dec 1st, 2009
Reengineering is a fundamental rethinking and radical redesign of business processes to achieve dramatic improvements in cost, quality, speed, and service, this is the same process while Re-engineering an Organization.Idan Halfon
-
olap and oltp
what are the main important differences between olap and oltp
ihatehyperion
- Dec 22nd, 2007
olap:online analytical processing is that which describes procesing at warehouses.oltp:online transactional processing is that which describes at the operational sites..oltp &nb...
-
can you convert a snowflake schema in to star schema?
idanh79
- Dec 1st, 2009
Yes, you can do it by denormalization of the dimensions into one (and wide) dimension, it is depends of your needs.Idan Halfon
sixto.dsilva
- Sep 25th, 2008
Yes right said both model are designed for different purpose , I think star schema is very informative for business users unlike snowflake which is bit complicated with lot of small , small tables. If...
-
what is the life cycle of data warehouse projects
idanh79
- Dec 7th, 2009
1. project planning2. business requirement definition3. dimension modeling+ technical architecture design4. pysical design+ product selection5. data staging design and development+end-user application development6. deployment+QAIdan Halfon
sulee
- Aug 22nd, 2007
STRAGEGY & PROJECT PLANNINGDefinition of scope, goals, objectives & purpose, and expectationsEstablishment of implementation strategyPreliminary identification of project resourcesAssem...
-
How would you handle conditional formats in BI
idanh79
- Dec 1st, 2009
You can use calculated members in OLAP cube and change the format accordingly the value of the cell.Idan Halfon
sithu
- Mar 24th, 2007
There are lot of ways are there to use the conditional formatting, most of the Process flow maintains more attention in the loops, alias and contextCheers,Sithusithusithu@hotmai.com
-
Let me know clearly what is the difference between hierarchies and levels
thumatinagaraju
- Nov 2nd, 2006
Hi nice ans u given and i think we can add number of of levels under hirarchy
-
-
What is the difference between Business Requirement Document and Use case Document. What is the difference. I need a good BRD and UC template.
idanh79
- Dec 1st, 2009
The UC is more technical analysis, the business requirement document is a word document which includes business analysis
mrnutt
- Sep 12th, 2008
A requirements document defines the business needs for a project. A Use Case Document defines the behavior of a system given a set of user interactions.
-
What is Data Warehouse
Data Warehouse Data from different data sources is stored in a relational database for end use analysisData from different data sources is stored in a relational database for end use analysis Data is organized in summarized, aggregated, subject oriented, non volatile patterns. Data is a data warehouse is consolidated, flexible collection of data Supports analysis of data but does not support online...
idanh79
- Dec 2nd, 2009
DWh is (6 important points about DWH) : 1. Dedicated Data Base 2. Integrated Data 3. Subject Oriented 4. Time Variant 5. Nonvolatile 6. Decision Support Idan Halfon
jglickma
- Nov 25th, 2008
Okay there are two camps on this Bill Inmon which is Date and Coddbased database design that has grown into the ODS reporting DSS database and of course Ralph Kimball whose mythology comprises of a st...
