Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What are the Advantages of de normalized data?

Question Posted / swetha

Answers were Sorted based on User's Feedback



What are the Advantages of de normalized data?..

Answer / kris

De Normalised Data:

A table storing denormalised data occupies more space
because lot of duplicate information creeps in when we
denormalise a table.

As less number of join conditions are required to retrieve
data from one/more denormalised tables, the performance
will be fast.

DWH environment prefers denormalised data structures.

Is This Answer Correct ?    27 Yes 2 No

What are the Advantages of de normalized data?..

Answer / mahesh

Denormalized data makes data retrieval operation faster and
reliable due to minimum number of joins used for
it.Therefore it improves the performance of the system.

Is This Answer Correct ?    0 Yes 1 No

What are the Advantages of de normalized data?..

Answer / eric yang

De-normalized data can save more space and have better
performance when run a sql for it

Is This Answer Correct ?    0 Yes 21 No

Post New Answer

More Informatica Interview Questions

How might you approve all mappings in the archive all the while?

0 Answers  

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

What is a filter transformation and why it is an active one?

0 Answers  

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

how do u tune queries?

1 Answers  

how you will maintain version?

3 Answers   CTS, TCS,

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

why u go for dimensions ?

3 Answers   TCS,

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

how to work with mapplet designer in informatica?

7 Answers  

For more Informatica Interview Questions Click Here
Categories