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
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
where to store informatica rejected data?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
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
What is the need of etl tools?
Explain the shared cache and re-cache?
How to improve the performance of a session using sorter transformation?
What are the tasks that can be performed using sq?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
In warehouses how many schemas are there?
Name the different lookup cache(s)?
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the prerequisite tasks to achieve the session partition?
