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?

1126

Mention the difference between ceil and floor functions in sas?

1155

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

1120

What is substr function?

1190

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

1079

How can sas program be validated?

1036

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

1117

What is a put statement?

1200

How to read an input file in sas?

1142

How sas treats the dsd delimiters?

1216

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

1317

how to remove duplicates using proc sql?

1148

How to display duplicate observations in data?

1 1671

What are common programming errors committed in sas

1147

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

1351

Un-Answered Questions { Data Warehouse }

What is logical data model?

1204

How can you create a macro variable with in data step? : sas-macro

1043

Explain hybrid slowly changing dimension?

1006

What is the difference between a cascading report and drill through the report?

1174

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

1990

in reporting we add some new objects,how we get the count of the newly added objects to the report

2193

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2494

What is a joint child?

946

What are the benefits of data processing according to you?

1216

Explain me what is vldb?

933

Tell me about % include and % eval? : sas-macro

1144

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1128

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2182

What is surrogate key? Where we use it? Explain with examples.

1027

what is a prompt value in report studio and variables ?

2714

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