Define degenerate dimension table
Give a brief note on the term degenerate dimension table?
Expert
The dimensions which are persevered in the fact table are named as dimension table. Such dimensions don’t hold its individual dimensions. Mapping doesn’t take place for the columns accessible in fact tables. The values in the table are neither dimension nor evaluates.
How to handle decimal places while importing a flatfile in informatica?
Explain the Hash file and the Sequential File?
Explain the drill mode?
Specify the vaious types of data warehouses?
Explain about Server Job and Parallel Jobs?
State some of the sectors where the data warehousing and data mining are utilized.
Write down the Target Types on the Server?
Briefly explains the three kinds of SQL commands?
Clarify briefly why dimension tables is de-normalized in the nature?
Explain what is meant by the term stored procedures?
18,76,764
1921976 Asked
3,689
Active Tutors
1424719
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!