Why fact table is in a normal form?
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.
Tell me what is full load & incremental or refresh load?
Explain what are the various reporting tools in the market?
How to join 3 database like flat file, oracle, db2 in informatrica?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
What is defined as partial backup?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
How does data mining and data warehousing work together?
What is a staging area? Do we need it? What is the purpose of a staging area?
What is VLDB?