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.
- 1 Answers
- 5697 Views
- IBM, I also Faced
- E-Mail Answers
Answer / bluegems
Answer is c.)add time period simply and make it
not null.
| Is This Answer Correct ? | 4 Yes | 1 No |
Explain differences between star and snowflake schemas?
What is difference between a connected look up and unconnected look up?
What is the differences between star and snowflake schemas?
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain dimensional modelling?
Explain what is data validation strategies for data mart validation after loading process?
Explain vldb?
WHAT IS FACT LESS FACT TABLE?
Which kind of index is preferred in DWH?
What is metadata in context of a datawarehouse and how it is important?
Teradata 
