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 3053

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 6228

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

GSK,

1 5572

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 10485

what is the use of catalog?

Cognizant,

1 6265

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 8880

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 6188

Un-Answered Questions { Data Warehouse }

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2179

plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

2353

What are the possible data marts in retail sales?

996

Where the data cube technology is used?

959

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

987

Demonstrate experience in maintaining quality process standards?

2552

How do you achieve schema object version control?

1000

can we override a native sql query within informatica? Where do we do it? How do we do it?

1055

What is a pdv and what are its functions?

1152

Difference between sum function and using “+” operator?

1152

What will be the skew for, input file->partition by key-> partition by round robin->output file

969

define under feeding?

which r the connectors used in san?

2188

Which are the different editions of informatica powercenter that are available?

1034

what is sas metadata repository? : Sas-bi

1118

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