why dimenstion tables are denormalized in nature ?
Answers were Sorted based on User's Feedback
Answer / siddu
For fast retrieval(to Perform a SELECT Operation)
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
In which circumstances that informatica server creates Reject files?
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
How can you access the remote source into your session?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
what is the difference between Informatica 7.1 and Abinitio?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is a unit Testing?
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
How to recover sessions in concurrent batches?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),