Answer / srinath gatpa

normalization is a process of spliting the table in to the
pices so that we can reduce the data redundancy problem

it contain more no. of tables so it will take more time to
execute
it will decreases the performence

Answer / sharath.dwh

NORMALIZATION MEANS TAKING A RAW DATABASE AND BREAKING IT
INTO LOGICAL UNITS CALLED TABLES IS CALLED NORMALIZATION.


DENORMALIZATION MEANS TAKING A NORMALIZED DATABASE AND
MODIFYING IT TO ALLOW CONTROLLED REDUNDANCY
FOR INCREASING DATABASE PERFORMANCE IS CALLED
DENORMALIZATION.

Answer / suman palisetty

Normalization is the process of reducing complexity by removing redundancy.

-----------------What is Singleton?

1 Answers   BoA, Cap Gemini, TCS,

---

What is the difference between macro & Parameter

1 Answers   IBM,

---

what is the difference between count and running-count functions?

1 Answers  

---

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

0 Answers  

---

Why are meta service important then other services?

0 Answers  

---

What is called materialized view?

0 Answers  

---

Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith

2 Answers  

---

how to get the all values from a prompt using 'ALL' use and display value in prompt

3 Answers  

---

How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).

1 Answers  

---

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

0 Answers  

---

How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?

1 Answers   HCL, iGate,

---

if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?

3 Answers   CTS, TCS,

---