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 the Difference between SetVariable and setmaxvariable in informatica?

1 23790

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

TCS,

4 9837

in u r data u having duplicates how to fetch the latest data in our report?

2 5635

Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1837

Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???

IBM,

1 4844

% let A=3+4 what is result

Satyam,

4 7563

how to delete the duplicate columns permanently in SQL

Satyam,

2 6164

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1897

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

Amdocs, Deloitte,

3 33420

How to generate surrogate key without using surrogate key stage?

IBM,

6 30561

how can get the first and last observations in a dataset using Proc SQl?

Satyam,

4 13218

how can you sort the dataset having millions of OBS(instead of sort procedure?

EXL,

4 10286

What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?

Wipro,

3 5022

Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva

1 4768

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 7335

Un-Answered Questions { Data Warehouse }

What is the ab initio business rules environment (bre)?

1111

What are the important Features of Redshift?

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2143

for whom is sas data integration studio designed? : Sas-di

950

Explain absolute filter?

905

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2224

Explain what is the architecture of abinitio?

1149

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1953

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9739

Explain degenerate dimension table?

986

What do think which one is the better joiner or look up?

1144

Differentiate between sas functions and sas procedures.

1149

----------------Describe DWH Architecture?

2013

Explain the difference between native sql and cognos sql?

933

I need to set predefined condition. How I do this?

956

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