What are the Advantages of de normalized data?
- 3 Answers
- 8227 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 |
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
how to run 2 workflows sequentially. plz respond what is the process?
In session log thier should not be a single error how will u do
What is exclusive and normal mode for repository services?
what is the size of u r project? and what is the size of source file?
what is mapping optimization? wat are the techniques for tat
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?
Clarify the utilization of aggregator cache record?
Reusable transformation and shortcut differences
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
Is it possible to update the target table with PK?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
Teradata 
