why dimenstion tables are denormalized in nature ?




Answers were Sorted based on User's Feedback



why dimenstion tables are denormalized in nature ? ..

Answer / siddu

For fast retrieval(to Perform a SELECT Operation)

Is This Answer Correct ?    3 Yes 0 No

why dimenstion tables are denormalized in nature ? ..

Answer / 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

why dimenstion tables are denormalized in nature ? ..

Answer / ankit kansal

As a denormalized table structures for a database the number
of joins to fetch the data turns out to be less and hence selection to the data becomes faster.

selecting data from one table is always better than selecting the same data from multiple tables.


http://deepinopensource.blogspot.in/

Is This Answer Correct ?    1 Yes 0 No



Post New Answer



More Informatica Interview Questions

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,


If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  


explain about session partitions ?

1 Answers  


i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,


What is meta data and system catalog?

2 Answers  






In Which scenario did u used Incremental loading?

2 Answers  


How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,


How to elaborate powercenter integration service?

0 Answers  


What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,


Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  


I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,


what is service oriented architecture in Informatica 8 version

1 Answers   TCS, IBM, Cap Gemini, Systech,






Categories