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 to join three sources using joiner? Explain though mapping flow.
Can you use flat files in Mapplets.
What is the sequence generator transformation in informatica?
can anyone suggest best free Talend data integration training online
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Can informatica load heterogeneous targets from heterogeneous sources?
Briefly define a session task?
How are the sources and targets definitions imported in informatica designer?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the components of the workflow manager?
What is the use of transformation?
Explain your project of banking domian.
How identifying bottlenecks in various components of informatica and resolving them?
What is incremental aggregation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?