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
- 5143 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bluegems
Answer is c.)add time period simply and make it
not null.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
Explain what is type 2 version dimension?
What are the approaches used by optimizer during execution plan?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What are data validation strategies for data mart validation after loading process?
Explain difference between view and materialized view?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What is the difference between snowflake and star schema?
Explain me what is vldb?
Explain what are the methodologies of data warehousing?
Where the applications and where
What is drilling across?
Tell me what is full load & incremental or refresh load?
Where do we use semi and non additive facts?
How to join 3 database like flat file, oracle, db2 in informatrica?
