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.
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 if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Can you pass sql queries in filter transformation?
What is data type of the surrogate key?
What is the difference between drill through and masterdetail reports?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What is data analytics in simple terms?
How to design file watch jobs?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What are data modeling and data mining?
What are various warehousing tools?
How to add a number to a macro variable?
Explain what are the different methods of loading dimension tables?
What is the main difference between inmon and kimball philosophies of data warehousing?
What is normalization, first normal form, second normal form, third normal form?
What according to you might be the future of data warehousing?