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 |
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
How would you join a node to the already existing domain?
What are the Advantages of de normalized data?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
what is the -ve test case in your project.
How can repository reports be accessed without sql or other transformations?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
tell me about your project functionality
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
What is rank transform?
What is hash partition?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?