-
Design a DWH Table based on the given source
We have a source which provides data in the following format? Design DWH tables based on this . Suggest whether you would keep the existing structure or whether you would break them apart into Separate Tables?
ItemId PropertyId Value
A1 10 Black
A1 20 16gb
A1 30 Iphone6
A1 1000... -
What is aggregation in DBMS?Explain in simple words.
Read Best Answer
Editorial / Best Answer
Bapineedu Bollempalli- Member Since Sep-2011 | Sep 18th, 2011
A concept which is used to model a relationship between a collection of entities and relationships. It is used when we need to express a relationship among relationships. Aggregation - a feature of the entity relationship model that allows a relationship set to participate in another relationship set. This is indicated on an ER diagram by drawing a dashed box around the aggregation.
Nitin Rathod
- Apr 15th, 2018
Aggregation is an abstraction through which relationships are treated as a higher level entities
Ex :- There exites a ternary relationship teaches between a teacher, department and subject entites, than relationship will be represented as.Ajmal Hussain
- Nov 25th, 2017
Aggregation of processes, when two entities are treated as a single entities then it is known as aggregation. Here center and courses are acting as a single entitys and then enquires with visi...
-
-
-
Database Design
I have these questions and looking for validation, these questions are part of test:
Foreign keys implement:
a) one to one relationship
b) m:n relationship
c) one to many relationship
d) recursive relationship
e) a, c and d are true
Identify the dependency type shown by the attribute PATIENT- BALANCE. CHAGRES (PHYSICIAN #, PATIENT#, PATIENT... -
In which normal form is the dimension table and fact table in the schema?
SashaFroyland
- Mar 2nd, 2008
Unlike OLTP, the goal of dimensional and fact modeling is not to achieve the highest Normal Form but rather to make key performance indicators (often sought after measures) readily accessible to ad-do...
-
What is an artificial (derived) primary key? When should it be used?
ins
- Nov 9th, 2015
Is it possible to use derived primary as foreign key?
mvg_mca
- Mar 12th, 2010
A derived key comes from a sequence. Usually it is used when a concatenated key becomes too cumbersome to use as a foreign key.
-
-
Form of Fact and Dimension Table
Fact table is in normal form or demoralized form?
Dimension table is in which form? Explain -
Generally speaking,for a weak entity set to be meaningful it must be part of a
1. one-to-one relationship 2. one-to-many relationship 3. many-to-many relationship 4. depends on a particular situation
-
-
What is fish-bone analysis?
Explain with an example
Read Best Answer
Editorial / Best Answer
Answered by: Ade
- Apr 4th, 2012
Fish-bone Analysis is a cause and effect analysis tool that helps to identify the problem and causes of the problem using a fish-like structure - the problem is at the head of the fish and the skeleton are the causes. Example is if an organization is experiencing decline in profit, the possible causes could be increase in cost of production, decline in revenue, competition in the market, substitute for our products etc. This analysis is usually conducted in a brainstorming session.
MANAS
- Dec 3rd, 2014
PPPP
P=PEOPLE
P=POLICY
P=PROCESS
P=PROGRAM
FISH BONE DIAGRAM
HERE WE CAN CHECK RCA FOR FAILURE. WHY FAILURE HAPPENED. WHICH P HAVE CREATED PROBLEM AND HOW WE CAN COVER UP NEXT.Ade
- Apr 4th, 2012
Fish-bone Analysis is a cause and effect analysis tool that helps to identify the problem and causes of the problem using a fish-like structure - the problem is at the head of the fish and the skeleto...
-
Database Structure Change
We already have a database structure, but it is the structure without normalization and very confused and in need of change, but already has a large volume of stored data, for example, all financial data company, which finance department officials are afraid of losing.
We are undecided about remodeling the entire structure of the database and retrieve the most basic and all that is possible,...
Read Best Answer
Editorial / Best Answer
Bapineedu Bollempalli- Member Since Sep-2011 | Sep 18th, 2011
What ever data base structure you have you can get a Logical model out of it using Reverse Engineering. Erwin is one data model tool which does it. You should apply normalizing techniques to bring the same to a 3NF (Normal Form) and reduce the redundancy. Creating new entities by breaking up of de-normalized entities. Resolving many to many relationships. Finally create a new database structure (Physical Model) based on 3NF from the logical model. Once you acheive a model in 3NF you can do Data migration by simple ETVL ( Extract, Transform, Validation and Load) from old data structure to new data structure. Before doing it your High Level Design should have proper Data mapping document and Metadata document so that you do not lose data.
Rohit
- Nov 18th, 2012
It purely depends what kind of problem you are facing currently. Performance issue can be dealt in n different ways, you need to see the current configuration of DB, the queries, the hardware etc. If ...
Bapineedu Bollempalli
- Sep 18th, 2011
What ever data base structure you have you can get a Logical model out of it using Reverse Engineering. Erwin is one data model tool which does it. You should apply normalizing techniques to bring the...
-
MVC Design pattern
what is the difference between MVC1 and MVC2 in j2EE?
Read Best Answer
Editorial / Best Answer
Sandhya.Kishan- Member Since Mar-2012 | May 14th, 2012
1.MVC1 consists of Web browser accessing Web-tier JSP pages. The JSP pages access Web-tier JavaBeans that represent the application model, and the next view to display is determined by hyperlinks selected in the source document or by request parameters. 2.MVC1 is page-centric design, meaning any JSP page can either present in the JSP or may be called directly from the JSP page. 3.MVC1 Combines both presentation logic with the Business logic. 4.MVC1 we can have multiple controller servlets. 1.MVC2 introduces a controller servlet between the browser and the JSP pages. The controller centralizes the logic for dispatching requests to the next view based on the request URL, input parameters, and application state. 2.MVC2 removes the page-centric property by separating Presentation, Control logic and Application state. 3.MVC2 can have only one controller servlet .
Sandhya.Kishan
- May 14th, 2012
1.MVC1 consists of Web browser accessing Web-tier JSP pages. The JSP pages access Web-tier JavaBeans that represent the application model, and the next view to display is determined by hyperlinks sele...
-
What is a toponomy database ?
Read Best Answer
Editorial / Best Answer
Answered by: Sandhya.Kishan
- Apr 18th, 2012
Toponomy database is a collection of data related to the study of place names, their origins,meaning,topology and their use.
Sandhya.Kishan
- Apr 18th, 2012
Toponomy database is a collection of data related to the study of place names, their origins,meaning,topology and their use.
-
What is difference between query calculation and layout calculation
Read Best Answer
Editorial / Best Answer
Sandhya.Kishan- Member Since Mar-2012 | Apr 11th, 2012
The query calculation helps to create a report to add a new row or column with values that are based on a calculations. Layout calculation helps to create a report which contains run time information such as current time, date, and user name.It does not perform any operations on data.
Sandhya.Kishan
- Apr 11th, 2012
The query calculation helps to create a report to add a new row or column with values that are based on a calculations.
Layout calculation helps to create a report which contains run time information such as current time, date, and user name.It does not perform any operations on data. -
How to capture webtable values
Read Best Answer
Editorial / Best Answer
Sandhya.Kishan- Member Since Mar-2012 | Apr 11th, 2012
By using the function getroproperty("field name") we can capture webtable values.
Sandhya.Kishan
- Apr 11th, 2012
By using the function getroproperty("field name") we can capture webtable values.
-
What is the difference between star flake and snow flake schema?
Read Best Answer
Editorial / Best Answer
zahoorahmad- Member Since Apr-2006 | Apr 12th, 2006
Star Schema:
Well in star schema you just enter your desired facts and all the primary keys of your dimensional tables in Fact table. And fact tables primary is the union of its all dimension table key. In star schema dimensional tables are usually not in BCNF form.
SnowFlake:
Its almost like starschema but in this our dimension tables are in 3rd NF, so more dimensions tables. And these dimension tables are linked by primary, foreign key relation.
Wassim Saade
- Nov 23rd, 2011
Star flake schema's are snowflake schema's where only some of the dimension tables have been denormalized.
Every star flake schema is also a snowflake schema.
Not every snowflake schema is a starflake schema.
A snowflake schema with all of its dimension tables normalized is not a starflake schema.
-
Informatica Architecture
Can you Explain about Informatica Architecture ? and what difference between service based and service oriented ?
Read Best Answer
Editorial / Best Answer
Answered by: venkatesh
- Sep 21st, 2011
|----------------------------|---------------------------------|-------------------| | SOURCES |client tools | TARGET | | like ,oracle,db2 |-------------------------------- | | | |powercenter repositery | | | |------------------------------- | | |________________|repositery server | | --------------------------------|-------------------|
venkatesh
- Sep 21st, 2011
|----------------------------|---------------------------------|-------------------| | SOURCES |client tools | TARGET | | like ,oracle,db2 |-...
-
What is ERD?
Data Modeling Interview Questions
Read Best Answer
Ans