what is normalization and denormalization

Question Posted / raaam.chowdary

2 Answers
14107 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is normalization and denormalization..

Answer / somu

IN Normalization is controlled by elimination redundant
data where as in Denormalisation is controlled by redundant
data.

Is This Answer Correct ?

2 Yes

0 No

what is normalization and denormalization..

Answer / shanu

Normalisation is a Process of decomposing the tables into
number of succesive tables to avoid Data Retundancy and
Inconsistency

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Data Stage Interview Questions

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers

what is meta data? Explain? Where it is used?

9 Answers

What are some different alternative commands associated with "dsjob"?

0 Answers

what is data mapping

2 Answers

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers UHG,

how many dimentions and fact tables used in your project and what are names of it?

3 Answers Tech Mahindra,

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

5 Answers TCS,

sed,awk,head

0 Answers CTS,

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers ME,

What are system variables and sequencers in datastage

0 Answers

data stores in which location while using data set stage as the target?

1 Answers IBM, TCS,

Is possible to create skid in dim,fact tables?

0 Answers NTT Data,

For more Data Stage Interview Questions Click Here