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

what is hash files in sas and why we are using this one in sas?

L&T, SAS,

2217

what is validvarname and varnum? why we are using this options; explain with a syntax for this options?

Max India,

1 6350

i want to upload titles and footnotes to excel file?how it is possible?

1 3051

i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?

3 6224

i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?

GSK,

1 5571

i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?

L&T,

3 7409

i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?

GSK,

6 10483

what is the use of catalog?

Cognizant,

1 6264

How to eliminate duplicate records in informatica mapping? Explain with an example....

Cap Gemini,

1 8591

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

Cap Gemini,

3 8879

Using Expression transformation how to remove duplicate records from a relational source?

4 24859

what is SAS OPTIMIZATION?

2297

In PROC PRINT, can you print only variables that begin with the letter “A”?

8 14982

Could you please answers for this. 1.Code the tables statement for a single-level (most common) frequency. 2.Code the tables statement to produce a multi-level frequency.

2 5576

How do you add a number to a macro variable?

2 6186

Un-Answered Questions { Data Warehouse }

can we insert all types of charts in a list report? what r the realtime prompts?

2212

Explain substr function?

1110

for what purpose would you use the retain statement? : Sas programming

1096

What is cubes?

1071

How do you test for missing values?

1636

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1378

How many types of stage?

1179

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2058

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1109

How do you add a number to a macro variable? : sas-macro

1009

describe the interaction table in sas di? : Sas-di

1031

What is the size of the cube?

975

What is the difference between static cache and dynamic cache?

993

What is depict expression change?

1120

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1203

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