Explain can report net connect multiple datasource at a time in report creation time?
Compare aggregates and data marts
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?
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?
Ist the schema that a data warehouse system can implements.
How can we determine what records to extract?
Explain what are the vaious etl tools in the market?
What is defined as partial backup?
What is an OLTP (Online Transaction Processing) System?
Explain what are fact, dimension, and measure?
What is Sequence clustering algorithm?
What is DTS ?
What are steps we have to follow in designing the userfriendly universe?