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
Explain why we use partitioning the session in informatica?
What are the new features of informatica 9.x in developer level?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are different types of transformations available in informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is informatica metadata and where is it stored?
Write the unconnected lookup syntax?
Explain scd type 3 through mapping.
Enlist the differences between database and data warehouse.
Explain pushdown optimization $pushdownconfig parameter - informatica
Which files are created during the session rums by informatics server?
What is a mapplet/worklet in informatica?
What is the commit type if you have a transaction control transformation in the mapping?
Differentiate between router and filter transformation?
Mention few power centre client applications with their basic purpose?