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
- 4333 Views
- I also Faced
- E-Mail Answers
Answer / s
The answer should be option (a). Add time period as a part
of primary key
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain the difference between filter and conditin?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
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,
Explain how to generate iqd file from framework manager?
How to join 3 database like flat file, oracle, db2 in informatrica?
what are different ways of loading data to data warehouse using oracle?
Explain me what are conformed dimensions?
what is the difference between aggregate table and fact table ? how do you load these two tables ?
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,
What is staging area?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
Teradata 
