Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Advantages of de normalized data?
- 3 Answers
- 8884 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 |
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
What are the types of lookup transformation?
Differentiate between router and filter transformation?
How to recover the standalone session?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Briefly define reusable transformation?
with out using update strategy transnsformation how to update the data in mapping level
have u done any performance tuning? how u ll do?
Teradata 
