|
INTERVIEW QUESTIONS
DATA WAREHOUSING
DETAILS
Question: What is a look up table?
Answer: A look up table is nothing but a 'look up' it give values to referenced table (it is a reference), it is used at the run time, it saves joins and space in terms of transformations. Example, a look up table called states, provide actual state name ('Texas') in place of TX to the output.
|
|
|
Category |
Data Warehousing Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 8073 users |
Added on |
8/24/2014 |
Views |
69295 |
Rate it! |
|
|
Question:
What is a look up table?
Answer:
A look up table is nothing but a 'look up' it give values to referenced table (it is a reference), it is used at the run time, it saves joins and space in terms of transformations. Example, a look up table called states, provide actual state name ('Texas') in place of TX to the output. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is Data warehousing Hierarchy?
|
View Answer
|
|
What is junk dimension? What are junk dimension and degenerated dimension?
|
View Answer
|
|
What is the main difference between Inmon and Kimball philosophies of data warehousing?
|
View Answer
|
|
What are the advantages data mining over traditional approaches?
|
View Answer
|
|
Can a dimension table contains numeric values?
|
View Answer
|
|
How do you connect two fact tables ?Is it possible ?
|
View Answer
|
|
What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?
|
View Answer
|
|
What are the similarities between ROLAP and MOLAP?
|
View Answer
|
|
Which is the optimized method of extracting the data?
|
View Answer
|
|
What is data mining?
|
View Answer
|
|
What is real time data-warehousing?
|
View Answer
|
|
What are Data Marts?
|
View Answer
|
|
What is DATA integration?
|
View Answer
|
|
What are the steps to build the data warehouse?
|
View Answer
|
|
How does replication takes place between two sites?
|
View Answer
|
|
What is the use of bridge table. Can give a simple example?
|
View Answer
|
|
Can a Data Warehouse also be used for Transaction Database?
|
View Answer
|
|
What are the major differences between Informatica 7.1,8.1,8.5 and 8.6?
|
View Answer
|
|
I wanted to load only particular no of records suppose i have 100 records out of which i wanted to load first 10 records to target.
|
View Answer
|
|
If one wants to see the time dependent master data, what table is to be referred?
|
View Answer
|