how to find unique records in informatica level
What is the difference between star and snowflake schemas?
Define data warehouse?
What is a linked cube?
What is surrogate key?
What is real-time datawarehousing?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What is an OLTP (Online Transaction Processing) System?
How can we schedule the graph in unix?
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.
Explain when do we analyze the tables? How do we do it?
if we increase the number of dimensions will the rows in fact table increase or decrease??
Explain why are oltp database designs not generally a good idea for a data warehouse?