GENERALLY IN DWH, WE DO SELECT QUERY ONLY(99%).. SO THE DATA ARE NOT NEED

why dimenstion tables are denormalized in nature ?

Question Posted / vikki

Answer Posted / vikki

GENERALLY IN DWH, WE DO SELECT QUERY ONLY(99%)..
SO THE DATA ARE NOT NEED TO BE NORMALIZED AS IN DB WHERE WE DO UPDATE,SELECT,ALTER,ETC..

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the components of Informatica? And what is the purpose of each?

695

difference between informatica 8.1.1 and 8.6

3349

What is confirmed fact in dataware housing?

5914

What is informatica worklet?

699

what is the Default Source Option For Update Strategy Transformation?

856

Which transformation is needed while using the Cobol sources as source definitions?

817

What is a sorter transformation?

783

How to create a non-reusable instance of reusable transformations?

784

How to create or import flat file definition in to the warehouse designer?

720

Explain the pipeline partition with real time example?

751

what is the difference between informatica6.1 and infomatica7.1

1822

what is unit testing?tell me proceedure

1880

can anyone suggest best free Talend data integration training online

1348

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6156

What is a standalone command task?

775