-
What is CGID in normalizer transformation
Please provide me deep info on Normalizer !
Sirini
- Jun 14th, 2009
It is GCID which means Generic Column ID. When a Normalizer transformation is used to read Cobol sources, the Informatica Designer identifies the 'OCCURS' and 'REDEFINES' statements and generates 2 co...
-
Bridge Table
What is the use of bridge table. Can give a simple example?
Read Best Answer
Editorial / Best Answer
Sirini- Member Since Jun-2009 | Jun 14th, 2009
An example of a Bridge table would be relationship table between student_master and courses_master. A Student may participate in multiple courses and obviously in a course there will be multiple students. In this scenario to maintain relationships between student_master and courses_master we need another table, which may be called, Student_courses. This table will have all relationships between Students and Courses.A bridge table is a table that only contains the keys between the two tables in a many-to-many relationship. These tables typically consist of mostly key fields, the primary keys of the two tables needing the many to many relationships. Sometimes there are more data elements, but often there are only two columns, both foreign keys.
vijsarav11
- Oct 19th, 2009
Hi all... This is my view on bridge tables:Bridge table in simple can be called as reference tables. As the name indicates, this table can be used to link two tables with 1 reference id...
tisha24
- Oct 7th, 2009
A table which maintained to define the relationship between two different tables is known as bridge tables. For example, say there are two tables one table with employee information (an employee table...
-
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...
-
opposite is true?
">Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
justins707
- Jan 11th, 2010
When we refer to Star and Snowflake Schemas, we are talking about a dimensional model for a Data Warehouse or a Datamart. The Star schema model gets it name from the design appearance because th...
Chris
- Mar 29th, 2007
Star Schemas generally contain fact tables with fully denormalised dimension tables connecting directly to the fact table. A snowflake schema is a modification of this approach whereby the dimension t...
-
What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables
divya29july
- Feb 11th, 2010
Factless Fact table:Consider an example of Product on promotion, the fact table will contain information of only the products that were on sale and sold but not of those that did not sell as the fact ...
siraj.khan
- Aug 3rd, 2007
Semi-additive facts are those facts which can be aggregate according to the context. so, it can contain a fact but the factless fact table does not contain fact's but it contains the dimmentions. It's a type of a dimmentions.
-
How are the Dimension tables designed
divya29july
- Feb 11th, 2010
Dimension table contain the textual descriptors of the business. In a well designed dimemsion model, dimension table has many columns or attributes. Fields that are discretely valued description that ...
Kenny
- Jul 19th, 2005
Find where data for this dimension are located. Figure out how to extract this data. Determine how to maintain changes to this dimension (see more on this in the next section). Change fact table and DW population routines.
-
What is the main differnce between schema in RDBMS and schemas in DataWarehouse....?
Sam Kolta
- Apr 17th, 2010
User It is just an account name for the user Owns a schema Have the same name Create user command, create the user User can be considered schema User can created without schema It is the account for t...
senthil kumar B
- Feb 13th, 2006
Diff b.w OLTP and OLAP :------------------------OLTP Schema :* Normalized * More no.of trans* Less time for queries execution* More no.of users* Have Insert,delete and update trans. OLAP (D...
-
What Snow Flake Schema
Answered by Girinath.S.V.S on 2005-03-17 06:40:48: Snowflake schemas normalize dimensions to eliminate redundancy. That is, the dimension data has been grouped into multiple tables instead of one large table. For example, a product dimension table in a star schema might be normalized into a products table, a product_category table, and a product_manufacturer table in a snowflake schema. While this...
prodyot.sarkar
- May 13th, 2010
Snow-flake schema is a logical arrangement of tables in dimensional modeling where a centralized fact table references number of other dimension tables; however, those dimension tables are further nor...
harshadapj
- Jul 22nd, 2008
Closely related to the star schema, the snowflake schema is represented by centralized fact tables which are connected to multiple dimensionsIn the snowflake schema, however, dimensions are normalized...
-
What are Data Marts
Data Mart is a segment of a data warehouse that can provide data for reporting and analysis on a section, unit, department or operation in the company, e.g. sales, payroll, production. Data marts are sometimes complete individual data warehouses which are usually smaller than the corporate data warehouse.
ashwinijawalgekar
- Jun 9th, 2010
Data Marts: Data Mart is a subset of Data Warehousing. Depending upon the management decision the warehouse devides into smaller part according to their respective subject. eg sales is a data mart of xyz warehouse
spatnam
- Dec 9th, 2008
Datamart is a subset of datwarehouse. Data mart deals with single line of business like Sales, Purchase etc. Size of data will be less when compared to Datawarehouse.Some of the different types of datamart are Depndant datamart , Independant datamart, Hybrid datamart
-
What is data mining
Answered by Puneet on 2005-05-07 04:24:28: Data mining is a process of extracting hidden trends within a datawarehouse. For example an insurance dataware house can be used to mine data for the most high risk people to insure in a certain geographial area.
kumarram
- Jun 11th, 2010
Data mining is the concept of extracting information from large data bases likes data wharehouse.
raj.rajeev15
- Sep 13th, 2009
Datamining is nothing but a science of finding information from databases or datasets.
-
What is real time data-warehousing
ashwinijawalgekar
- Jul 7th, 2010
The Real time data warehouse is really a combination of real time (Current) and historical data warehouse.In real time world the historical systems are less valuables because of issues facing managers...
satyambabu
- Mar 22nd, 2006
Real time Data warehousing means combination of hetrogenious databases and query and analysis purpose and Decisionmaking and reporting purpose.
-
What is the need of surrogate key;why primary key not used as surrogate key
bcsandip
- Jul 16th, 2010
In DW, a fact table stores a few Primary keys of the corresponding Dimension tables. It will be always easier to get the desired record from the fact table when query is fired based upon a particular unique column and that is the another reason to introduce surrogate key.
srinuv_11
- Dec 8th, 2006
Datawarehousing depends on the surrogate key not primary key, for suppose if u r taking the product price it will change over the time, but product no. will not change but price will change over...
-
Data Mart Entity
If data is missing that is required as a primary key in a data mart entity from what sources can this information be gathered?
preekon
- Aug 24th, 2010
Data mart is considered to be a subset of datawarehouse, If the data is missing for primary key and the data source can be gathered from the list of entity derived from dimensions, but data mart ...
-
What are Aggregate tables
kevin0209
- Aug 30th, 2010
Aggregate table contains summarised data. The materialized view are aggregated tables.
sixto.dsilva
- Oct 1st, 2008
Aggregate table contains the summary of existing warhouse data , it contains data which is group accordingly (month , quartely etc) depending upon the business needs.For example you may contain transa...
-
What is DATA integration
OM PRAKASH JHA
- Sep 7th, 2010
Data integration involves data combining in different residing in different sources and providing users with a unified view of these data.This process becomes significant in a variety of situations bo...
tisha24
- Oct 22nd, 2009
Data from different sources (like flatfiles, CSV, oracle, db2,teradata, mainfraes etc.) are extracted and transformed in to a single specific pattern (unique structure) and is know as integration of d...
-
Explain ODS and ODS types.
chand.abinitio
- Sep 27th, 2010
ODS is defined as subject-oriented and integrated data and volatile
repository of data.
Contains current or near to current data
could be used for day to day reporting/ low-level analysis
updatable data store
contains detail data, no summarization
data in homogeneous form.
jaggu_mandya
- Jan 11th, 2008
It is designed to support Operational Monitoring. It is subject oriented,integrated database which holds the current,detailed data.data here is volatile
-
Non-Additive Facts
Give an example of non-additive facts?
rummyraj
- Oct 13th, 2010
Here is an actual example from my current project.We sell Parts globally. Each part is being sold at different price in different regions. Each part has different cost to the company in different regi...
-
High Speed Power Application
Which one of the following is used for high speed power application? a) BJT b) MOSFET c) IGBT d) TRIAC
-
Final Component of Dimensional Model
As a final component of the dimensional model, the architect can do all of the following EXCEPTA) identify entity relationships.B) add relevant dimensional attributesC) identify derived measuresD) identify derived facts
charlie2k
- Nov 27th, 2010
Identify the relationship is one of the first things to do. It is used for preparing the conceptual data model.The preparation of conceptual data model --> logical data model --> physical data model.
Data Warehousing Basics
Read Best Answer
Ans