Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

explain the difference between proc means and proc summary?

1074

Mention the difference between ceil and floor functions in sas?

1107

How to include or exclude specific variables in a data set?

1071

What is substr function?

1127

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

1010

How can sas program be validated?

982

Mention how to limit decimal places for the variable using proc means?

1074

What is a put statement?

1149

How to read an input file in sas?

1101

How sas treats the dsd delimiters?

1164

How can you limit the variables written to output dataset in data step?

1254

how to remove duplicates using proc sql?

1102

How to display duplicate observations in data?

1 1581

What are common programming errors committed in sas

1106

What are the difference between ceil and floor functions in sas?

1282

Un-Answered Questions { Data Warehouse }

What is the meaning of decode in informatica?

1083

What is degenerate dimension table?

956

how does sas handle missing values in sort order? : Sas programming

879

what can you learn from the sas log when debugging? : Sas programming

1030

Explain the use of proc gplot? : sas-grid-administration

940

Why fact table is in a normal form?

939

Explain me what are data marts?

1008

What is pmcmd command?

1053

What is difference between server jobs & parallel jobs?

994

Explain the tuning lookup transformation - informatica

958

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1878

what is the use of structures?how many nodes can u create in a structure?

2180

how do u handle performance issues in Informatica . where can u monitor the performance ?

4699

Is it possible to use a client with different version than that of its Informatica server?

1083

What is the use of datastage designer?

1098

For More Un-Answered { Data Warehouse } Questions Click Here