-
Data Modeling
What is the impact of Data Modeling Software Engineering?
JayashreePatil
- Jul 2nd, 2008
GUI Representation of a Data model of any system helps in understanding the data flow and relationship between the entities.
-
What is ERD?
-
-
-
Client Dependent table
What are the values given to the Field name,Data element and Type of a table to make it as a client dependent ?
-
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 |-...
-
Logical Database design
Discuss how you would use Storage structures mainly the tablespaces, Database Security features, Oracle Net services to logically manage what users can do or not to the database. Assume you would want to achieve partial database availability to different users at some times so that whilst some users can be able to access the database you disable some group from using the database or just change what...
-
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.
-
Describe collage as system?
Describe your university or college as a system.
What is the input?
What is output?
What is the boundary?
What is the components and their relationship?
The constraint
The environment
Draw a diagram of this system
-
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 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. -
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.
-
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...
-
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...
-
Can transfer function of a system be equal to its homogeneous solution?
Transform the following differential equation into a transfer function and find the homogeneous solution to the differential equation from the transfer function
-
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...
-
-
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
-
Form of Fact and Dimension Table
Fact table is in normal form or demoralized form?
Dimension table is in which form? Explain -
Data Modeling Interview Questions
Read Best Answer
Ans