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
How can we remove the duplicates from flat file source?
Explain about cumulative Sum or moving sum?
What is rank transform?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is a transaction control transformation?
Explain what transformation and how many are there in informatica?
Mention some types of transformation?
How union transformation is used?
Scheduling properties,whats the default (sequential)
Implementation methodology
What is lookup change?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
What is a router transformation?
Why sorter is an active transformation?
