-
Surrogate Key
Why do we use Surrogate Key?
Rajesh Swarnkar
- Feb 28th, 2012
Usually Surrogate keys are System Generated keys that can be used in place of missing primary key.
sadique_ghitm
- Nov 25th, 2011
A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data. A surrogate repres...
-
Relational and Dimensional Data Modeling
How can you say Relational is Normalized one and Data Warehouse i.e Dimensional modeling is De-Normalized one when both model follows the Primary Key Concept in its table to store Data
Iftikhar Alam
- Apr 8th, 2012
Data obtain from transactional source which is normalized on 3NF. It has been staged and demoralized the data and after denationalization of data re-normalized on 2NF and 3NF. Therefore, It is called Demoralized but it is normalized not like the transactional
madhavig
- Feb 16th, 2010
Dimensional modeling usually does with 2NF for dimensions and 3NF for facts.Dimensions are de-normalized for better query performance and for better understanding by business users.
-
Data Mining Advantages
What are the advantages of Data Mining over traditional approaches>
Emanisreddy
- Apr 17th, 2012
Data mining is nothing about analyzing the results with different prospects.
-
What is the difference between aggregate table and materliazed view?
Read Best Answer
Editorial / Best Answer
joshmohit- Member Since Oct-2010 | Nov 3rd, 2010
Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the database specific properties which might not be covered with the generic definition of aggregate tables.
Tom Haughey
- Apr 30th, 2012
?An aggregate table is a table that contains data that is summarized somehow, for example, it contains a summary of Customer by Product by Week. A more granular level of detail would be the transactio...
joshmohit
- Nov 3rd, 2010
Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the...
-
What is fan trap? How do you find out? How do you resolve that loop? What is chasm trap? How do you find out? How do you resolve that loop? How you provide security for reports? Whenever you open a report it refresh automatically? How do set this. Can you use different database for different universes? What are the types of universes?
PANGANAMALA SRINIVAS
- May 9th, 2012
Fan trap: one of the schema-tables in your physical realization via an rdbms has a 1:many relationship between two slave-tables but there is no path between the two slave tables! So we are clueless ab...
johnftamburo
- Mar 19th, 2009
A fan trap is a many-to-many relationship between two fact tables, bridged by a dimension.
-
Database and Data Warehouse
What is the relationship between company database and its data warehaouse?
Rajarao marisa
- Jun 6th, 2012
Hi, The main diff between database and data warehouse------> DW 1)Its stores historical & Summarized d...
prasadkawade
- Mar 20th, 2012
Company database contains all the current data. whereas the data warehouse of means data repository. Database stores all the data on which business runs but database repository contains the data that ...
-
SCD types
What are the types of slowly changingdimension ?Can you explain please types of slowly changingdimension in detail ?
vijaya
- Aug 29th, 2012
Slowly changing dimensions are 3 types. In scd-1 new data is inserted by deleting old one. so latest information is stored. In scd-2 we can maintain history of data for a particular item. new data is...
bhavikumehta
- Jun 26th, 2012
SCD are of following types: type 1 - updates changes without preserving history type 2 - stores history data by maintaining versions of the updated data type 3 - either stores current and previous ver...
-
1) Differences between DSS and OLTP.2) Explain Grouped cross tab.3) Define Surrogate key.4) What is IQD file.5) Expalin Reference cursor.
Janaki
- Nov 5th, 2012
3.Surrogate key is a sequencer which is used to uniquely identify a row in a OLAP. This helps in implementing SCD Type 2 in data warehousing.
rj_dwbi
- Apr 2nd, 2012
OLAP:
1). Store historical data of an organization
2). Data is used for BI/ business strategic decision
OLTP
1). Real time transactional data
2). Data is used to have track of transaction details. -
Informatica triggering
In informatica v 8.6
One workflow triggers another workflow.
How where do we put a distinct clause so that the duplicates are not reflected in the report formed by the second WF. first Wf does a partial load -
How to retrieve las ten or first ten rows from a flatfile
Praful
- Dec 17th, 2012
In datastage, we can use the External Filter stage, use the unix command head or tail to retrieve the particular lines from the flat file.
ambika shanmugam
- May 20th, 2008
Using the SORT operation, we can retrieve the set of records from the flat file Sample command;SORT FIELDS COPYSTOPAFT=10 (stop after 10th record)SKIPREC=10 (skip first 10 records)
-
-
-
Use of Unused port in Join component.
What is the use of the unused port in the join component? We have reject port. Difference between the reject port & unused port?
-
-
-
Types of Dimension
What are the types of dimensions? Can you explainthe each type in short?
priyank_divya
- Aug 28th, 2013
Conformed Dimension: Used across lines of businesses to gather information from across LOBs. Eg. if we want to know the deptnames where the avg salary of employees is more than the overall avg. Junk D...
Joe
- Aug 21st, 2012
1. Conformed Dimensions
2. Junk Dimensions -
Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs.
Karthikeyan E
- Oct 21st, 2013
RAID 1 --- Additional disk which stores the mirror image of original disk data.
RAID 5 - Uses XR algorithm and retrieves records when original disk failure.ravi_kumar_garre
- Jan 4th, 2008
The basic advantage of RAID is to speed up the data reading from permanent storage device (hard disk). Cheers,Ravi Kumar Garre
-
-
-
Data Warehousing Interview Questions
Sub Category
Questions
Answers
Last Updated
Read Best Answer
Ans