Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Junk Dimensions
Thanks for the quick reply. I've already done the dimensional analysis and have my dimensions figured out however there's a large list of attributes which don't really relate to each other or have any kind of hierarchy and creating a separate dimension for each single attrbute is bit of an...- shabut
- Post #3
- Forum: Data Warehousing/Big Data
-
Handle Duplicate enteries in Fact
There are different ways to handle this as suggested above. If these are true duplicates then a distinct will work however if the uniqueness is only based on few fields then in case of Oracle you could use the ROWID to remove duplicates for example: Select * from DuplicateTable Wehre ROWID =...- shabut
- Post #6
- Forum: Data Warehousing/Big Data
-
Junk Dimensions
I have a situation where we have to track number of loan appliations submitted and matched with lenders by almost every single attribute (around 45) on the application form. Some of the attributes are like Loan_Amount Frist_Mortgage, Second_Mortgage, Frist_Interest_Rate, Second_Intesrest_Rate...- shabut
- Thread
- Replies: 3
- Forum: Data Warehousing/Big Data
