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,

2218

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

Max India,

1 6357

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

1 3059

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 6237

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

GSK,

1 5578

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 7419

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 10506

what is the use of catalog?

Cognizant,

1 6273

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

Cap Gemini,

1 8598

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 8893

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

4 24871

what is SAS OPTIMIZATION?

2302

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

8 15003

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 5581

How do you add a number to a macro variable?

2 6196

Un-Answered Questions { Data Warehouse }

What are the uses of client software involved in teradata?

985

Can you define pivot?

1120

What are the different kinds of views available in a datastage director?

1033

What is the core of co> operating system?

1181

Define views in teradata with syntax.

1085

What are the limitations for memory allocation for SAS variables

1499

what make u disappointmnets in u r career

2200

What does Amp contain and what are all the operations that it performs?

1007

Explain the parallel data extension in teradata?

1103

Can Bo generates the Report from the cubical data Explain?

2039

what are the dimensions that you have in your current project?list them?

2024

How can you implement many relations in star schema model?

1007

Write types of folders present in cognos?

1080

How do we resolve attribute roles in microstrategy?

1161

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1093

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