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,

2271

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

Max India,

1 6460

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

1 3133

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 6377

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

GSK,

1 5644

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 7538

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 10669

what is the use of catalog?

Cognizant,

1 6348

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

Cap Gemini,

1 8673

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 9029

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

4 25017

what is SAS OPTIMIZATION?

2357

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

8 15259

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 5665

How do you add a number to a macro variable?

2 6292

Un-Answered Questions { Data Warehouse }

what is ds administrator used for?

1222

Can you define query studio?

1019

What do you code to create a macro? : sas-macro

1194

How does hashing happens in teradata?

1150

You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?

916

what type of graphs we will create(for 2+years candidates)?

2364

What is decode in informatica?

1259

What is cube grouping?

1156

can anyone explain me about retail domain project in informatica?

8004

What are the modules in Power Mart?

1022

what is online view?

1992

what is an ETL or ETT? And what are the different types?

7562

explain the environment varaibles with example?

1140

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2250

What is the purpose of having stored procedures in a database?

1224

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