Store (and count) non-fact records?
No Answer is Posted For this Question
Be the First to Post Answer
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
4 Answers IBM, MAHINDRA, Tech Mahindra,
What are aggregate fact tables ? why they are needed? give an example
What is a staging area? Do we need it? What is the purpose of a staging area?
How to eliminate duplicate rows from flat file?
what are different storage options supported by oracle ?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
Explain what is the extension of file to save template?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain the different types of data warehousing?
Where do we use semi and non additive facts?
What are session timeout and application timeout?
What are the methodologies of data warehousing?