Answer Posted / ankit kansal
As a denormalized table structures for a database the number
of joins to fetch the data turns out to be less and hence selection to the data becomes faster.
selecting data from one table is always better than selecting the same data from multiple tables.
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the session task and command task?
What is the need of an ETL tool?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is workflow monitor?
What are multi-group transformations?
What is a repository manager?
Please let me know how to make Data masking in informatica..
What is sq transformation?
What is a repository? And how to add it in an informatica client?
How many transformations can be used in mapplets.
If informatica has its scheduler why using third party scheduler?
How to partition the Session?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is powercenter on grid?
What are the restrictions of union transformation?