Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What are the different ways to implement parallel processing in informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Which is the t/r that builts only single cache memory?
Is there any target staging area in informatica not staging area
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How can informatica be used for an organization?
wat are deployement groups in informatica, how it will be used for developers
What is a connected transformation?
What are the components of workflow manager?
what is song in infrmatica...?
How many types of sessions are there in informatica.please explain them?
generate date / time dimension in informatica
What is the way to execute pl/sql script using informatica mapping?
How to create Target definition for flat files?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
