What are the Advantages of de normalized data?
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 |
how to convert the .doc docs into .txt format using informatica
In Which scenario did u used Incremental loading?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is parameter file?
In a sequential batch can u run the session if previous session fails?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
How to extract sap data using informatica? What is abap? What are idocs?
What do you mean by filter transformation?
what are the differences between powercenter 8.1 and powercenter 8.5?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.