-
Look Up Tables
What are lookup tables? Why they are used? Where they are used?
ponnarasuk
- Jul 9th, 2008
When a foreign key exists in a table, the foreign key’s table is sometimes referred to as a lookup table. The DEPARTMENT table in our example is a lookup table for the EMPLOYEE table. The value of an employee’s department can be looked up in the DEPARTMENT table
-
OLAP tools and Reporting tools
What is the difference between OLAP tools and reporting tools?
sinisdevan
- Jul 10th, 2008
By using OLAP tools you will be able to create a symantec layer of datamarts on which we can run reports.
-
Pivot Table inside Informatica
How to Pivot a table inside informatica?
Allowing data spread across multiple rows to be inserted into a single row in a different table.Col A Col B A 10 B 20After pivoting (Target Table)ID Value A Value B1 10 20How can this be achieved inside informatica?devidya
- Sep 25th, 2008
Use a router to denormalize the data and then merge them using a union transfomation. I think this is one of the ways to do it. All the Best.
-
Multi-Valued Dimension
Illustrate one detailed example for multi-valued dimension or bridge table?
ramanapaidi
- Jul 1st, 2009
Health care bill has line item of diagnosis, for which there could be multiple values
-
OOAD Object Oriented Analysis & Design
When is the need to do OOAD (Object oriented analysis & design)
subang
- Jan 17th, 2010
We use OOAD in order to design the system when overall requirements needed for developing the new system are clearly understood by the developer.
-
ERWIN Tool Model Print
If you take a print out of your model in ERWIN tool, What all you will be able to see?
rajeshkumar.san
- Dec 26th, 2008
According to the selection of print we can view in the print out. we will be able to view all the tables with their feild name, primary key, datatype, relation between the tables and their flow.
-
Kimball and Inmon
How anyone define the pracical difference between Kimball & Inmon?
Read Best Answer
Editorial / Best Answer
shashk- Member Since Jul-2010 | Aug 25th, 2010
Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their information from the data warehouse. In the data warehouse, information is stored in 3rd normal form.
Ralph Kimball's paradigm: Data warehouse is the conglomerate of all data marts within the enterprise. Information is always stored in the dimensional model.There is no right or wrong between these two ideas, as they represent different data warehousing philosophies.
In reality, the data warehouse in most enterprises are closer to Ralph Kimball's idea. This is because most data warehouses started out as a departmental effort, and hence they originated as a data mart. Only when more data marts are built later do they evolve into a data warehouse.shashk
- Aug 25th, 2010
Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their information from the data warehouse...
-
-
Lookup Performance
How does the usage of Dataset improve the performance during lookups?
sixto.dsilva
- Aug 17th, 2009
Correct me if i misunderstood your question. I think you want to know whether the usage data will improve the graph performance. I think definitely the usage of data will definitely improve the graph ...
-
-
-
Reconcialation Process
What is the Reconcialation Process?
v_madhu29
- Aug 11th, 2009
Reconcilation process is a systematic comparision between the data in Dataware house and data in source system.The comparision may be a set a predefined summary values or detailed data periodically.
-
ETL Load Frequency and Load Window
What is Load Frequency and Load Window in ETL?
zann1
- Sep 7th, 2009
ETL Load frequency is how often the ETL processes (that load data into the data warehouse) are run.Load Window is the time allocated for ETL load to execute.e.g. If the load is run daily, and the time allowed for execution is 8 hours then:ETL load frequency = dailyLoad window = 8 hours
-
SCD types and usages
What are the SCD types and what are its Usage?
pradeep16
- Oct 21st, 2009
SCD - Slowly Changing Dimensions. SCD usages in data warehouse are to store the history of transactions on dimensions. There are three types SCDs: Type1 - Just rewrite the record if there is a change...
-
Data Mart Data
Is data, transient or periodic in data mart? Explain
ashishsinha.dummy
- Nov 10th, 2009
Data marts are part of OLAP system. Data in datamarts cannot be trasient. Data will be updated in datamarts on a periodic or daily basis depending on the design of the data warehouse.-Ashish
-
Merge Dimension
What is the merge dimension?
Nicolas
- Apr 17th, 2010
Merge dimension is the action in Web Intelligence XI that allows to synchronize two or more data providers through common dimension. Once created, the merged dimension can be used as an object for rep...
-
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.
-
Degenarated Dimension
What is the use of Degenerated dimension? Where it is used?
gargupendar
- Mar 24th, 2011
A degenerate dimension is a dimension which is derived from the fact table and doesn't have its own dimension table.Example : Receipt number is the perfect example for degenerate dimension.
-
Dynamic Insert
What is Dynamic Insert?
mkm187
- Oct 5th, 2010
INSERT FIRSTWHEN SAL > 25000 THENINTO special_sal VALUES(DEPTID, SAL)WHEN HIREDATE like ('%00%') THENINTO hiredate_history_00 VALUES(DEPTID,HIREDATE)WHEN HIREDATE like ('%99%') THEN...
-
Data Warehousing Interview Questions
Sub Category
Questions
Answers
Last Updated
Read Best Answer
Ans