In dimension and fact table? which one holds big data?
Answers were Sorted based on User's Feedback
Answer / ravikumar2614
Fact table having huge data with less colomns..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / davankumar
Fact table has the big data bcoz fact table main tain
history data.
| Is This Answer Correct ? | 2 Yes | 1 No |
what is a time dimension? give an example?
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
Does Facttable Normalized or Denormalized?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is difference between a connected look up and unconnected look up?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
What is metadata reporter?
Can we insert and update a target table without using update strategy transformation?How?
how can we use sorter transformation in joins?
how can we check whether a particular cache is static or dynamic?
in performance wise union is past,union all is past