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 5741

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 7795

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 33559

How to generate surrogate key without using surrogate key stage?

IBM,

6 30797

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 10494

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

Wipro,

3 5180

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 4856

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

2 7471

Un-Answered Questions { Data Warehouse }

What is lookup table in etl testing?

1183

What is embedded metric?

990

How can we improve session performance in aggregator transformation?

1117

What are the designer tools for creating transformations?

1118

What is pmcmd command?

1121

Can you please send me the migration related issues .

2073

Explain how we drill up week to month?

1092

What are the different Lookup methods used in Informatica?

918

You have got the requirement from a client. Explain the technical approach you will take now.

973

What do you mean by blocking transformation?

1040

What is amazon redshift? How it work?

What is the report studio?

1018

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1965

Explain the difference between detect alias and detect context?

1104

How do you remove duplicate values in datastage?

1151

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