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 24066

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 10232

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

2 5839

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.

1931

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

IBM,

1 5058

% let A=3+4 what is result

Satyam,

4 8002

how to delete the duplicate columns permanently in SQL

Satyam,

2 6420

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

2007

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 33718

How to generate surrogate key without using surrogate key stage?

IBM,

6 31001

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

Satyam,

4 13607

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

EXL,

4 10677

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

Wipro,

3 5334

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 4935

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

2 7581

Un-Answered Questions { Data Warehouse }

What are the functions performed by bynet?

1092

What is level based metrics.how will you create it?

943

How will you enable or disable caching in the system level and table level?

935

what is the difference steps for data modeling?

2659

What is the difference between absolute and relative div positioning?

1101

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

830

Explain sessions and how many types of sessions are there?

1061

What are the types of containers in datastage?

1228

Mention what is rollup component?

1187

Can you execute macro within another macro? : sas-macro

1052

What parallelisms does Abinitio support?

1262

What are the ways in which macro variables can be created in sas programming?

1178

What is the difference between star and snowflake schemas?

1321

Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

1077

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3351

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