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 23941

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 10035

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

2 5740

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.

1881

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

IBM,

1 4962

% let A=3+4 what is result

Satyam,

4 7794

how to delete the duplicate columns permanently in SQL

Satyam,

2 6312

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

1953

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 33557

How to generate surrogate key without using surrogate key stage?

IBM,

6 30796

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

Satyam,

4 13441

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

EXL,

4 10493

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

Wipro,

3 5179

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 4855

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

2 7470

Un-Answered Questions { Data Warehouse }

Explain the use lookup tables and Aggregate tables?

977

What are the different versions of sas that you have used until now? : sas-grid-administration

1339

Please explain the different stages in creating a report in cognos report net?

1007

what are the errors faced while bursting the reports and how to solve those errors?

2017

What is the size of the cube?

975

what is the difference between cardinality and Nullability?

2943

What is the conflict resolution window?

1042

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?

2009

Highlight a few of the advantages that ETL tools have over Teradata.

1090

what is sas metadata repository? : Sas-bi

1117

What are the types of jobs we have in datastage?

1075

What is broadcasting and replicate?

1171

How can we create a dynamic column name in cognos?

956

Explain hybrid slowly changing dimension?

1006

We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

1437

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