Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Advantages of de normalized data?
- 3 Answers
- 8815 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Can you generate reports in Informatcia?
How many joins in Informatica
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
if i am having 10 records in source, i want 20 records in target...how will you do it
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
What are reusable transformations in how many ways we can create them?
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
How to eliminate duplicates in FF and oracle both
What is the difference between informatica 7.0 and 8.0?
Teradata 
