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 6353

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

1 3056

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 6234

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

GSK,

1 5574

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 7411

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 10500

what is the use of catalog?

Cognizant,

1 6269

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

Cap Gemini,

1 8594

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 8888

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

4 24869

what is SAS OPTIMIZATION?

2301

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

8 14995

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 5577

How do you add a number to a macro variable?

2 6193

Un-Answered Questions { Data Warehouse }

explain html document?

1017

Explain the scenario which compels informatica server to reject files?

1171

What is ods (operation data source)?

1002

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2501

Explain compound key?

990

Explain transaction control transformation in informatica

1272

what is chore commit property?

Differences between connected and unconnected lookup?

1223

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

What are the types of containers?

1237

How do you import and export data into datastage?

1237

what is enterprise guide? What is the use of it? : Sas programming

1022

What are the possible data marts in retail sales?

1000

What is difference between query studio and report studio?

1092

What are the various types of layout supported by abinitio?

1032

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