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 performance considerations when working with aggregator transformation?

1152

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2003

What are ETL Tools?

1118

What is intricate mapping?

1205

How is union transformation utilized?

1009

Explain the informatica workflow?

1074

complex mapping ur project u r invlve can u explain and give real time example give me ?

2301

how many types of dimensions are available in informatica?

1100

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2057

What is the difference between a connected look up and unconnected lookup?

966

What is substr in informatica?

1208

What does update strategy mean, and what are the different option of it?

1091

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

2278

list out all the transformations which use cache?

1184

Explain how many types of dimensions are available in informatica?

1098