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 23940

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 10025

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

2 5738

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 7791

how to delete the duplicate columns permanently in SQL

Satyam,

2 6310

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 30793

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

Satyam,

4 13437

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

EXL,

4 10489

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

Wipro,

3 5178

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 4853

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

2 7466

Un-Answered Questions { Data Warehouse }

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1949

Explain a linked cube?

955

What are the various file formats involved in reportnet?

976

What is the purpose of having stored procedures in a database?

1148

For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

1007

What do you understand by ‘ibm predictive maintenance and quality’?

993

Explain two-tier connection?

942

Suppose 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?

975

Give some examples where proc report’s defaults are same as proc print’s defaults?

1113

Differences between connected and unconnected lookup?

1218

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554

What is your spectra photometer working principles?

982

tell me 5 session failure in real time how can you solve that in your project?

2302

Do we need an etl tool?

1005

What are the applications primarily used by business analyst? : Sas-bi

994

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