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,

2155

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

Max India,

1 6228

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

1 2939

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 6075

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

GSK,

1 5464

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 7261

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 10231

what is the use of catalog?

Cognizant,

1 6163

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

Cap Gemini,

1 8480

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 8736

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

4 24633

what is SAS OPTIMIZATION?

2232

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

8 14594

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 5444

How do you add a number to a macro variable?

2 6059

Un-Answered Questions { Data Warehouse }

What are the different ways to implement parallel processing in informatica?

1340

Could anyone give brief explanation bout datastage admin

2310

What are logical views used for in microstrategy?

882

How to handle multi value dimensions?

2219

What is the difference between olap and datawarehosue?

896

where to use sas business intelligence? : Sas-bi

1003

Describe data concatenation?

1005

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4068

Differentiate between data file and descriptor file?

988

What happens if the owner of an object does not exist in the destination project?

855

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1017

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

867

What is data analysis?

896

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1901

What is Analysis Services?

2055

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