Data Warehouse Interview Questions
Questions Answers Views Company eMail

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

577

why is a stop statement needed for the point=option on a set statement? : Sas programming

575

which date functions advances a date time or date/time value by a given interval? : Sas programming

521

What do the mod and int function do? : Sas programming

564

what has been your most common programming mistake? : Sas programming

547

what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

711

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

559

what are some good sas programming practices for processing very large data sets? : Sas programming

500

what is the use of proc sql? : Sas programming

580

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

536

What are fundamental stages of data warehousing?

527

What are aggregate tables and aggregate fact tables?

516

What is vldb(very large databases)?

533

What is the difference between view materialized view and view?

579

Explain datawarehousing?

547


Un-Answered Questions { Data Warehouse }

Explain security role?

536


Give a justifiable reason why Multi-load supports NUSI instead of USI.

662


how we can generate cubes in cognos?

5


How we are going to decide which schema we are going to implement in the data warehouse?

476


Explain attribute role?

600






Define enterprise data warehousing?

623


What interface is used to connect to windows based applications?

574


State the difference between an operational datastage and a data warehouse?

596


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1068


Explain what are the different types of data warehousing?

508


What is amazon redshift?

1


what are the session parameters? How do u set them?

1505


Compare dataset and fileset?

555


What do you mean by worklet?

618


How we can monitor the performance of Redshift data warehouse cluster.

5