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

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

TCS,

4 11727

How to write a condition for multy select in conditional formatting... Eg:- i added list,crosstab, barchart, columchart, guagechart, pie chart for value prompt by using static choices.. if i select multiple that all the things has to be display.. this is requirement how is possible to display..

IBM,

2 6208

What is Clipboard? How to import XML file into Clipboard?

CSC, HCL,

2 8263

What is the size of PDV?

L&T,

2 13624

Define Dynamic push down optmization?

HP,

2309

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

Barclays,

9 15449

how to get max value record into one target and remaining records into another target?

Accenture,

2 9606

Hi can any one explain me what is Major Difference between Dashboard and Document Please assist me.

CTS,

5 9003

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3633

How many ways to overcome a missing values???

HSBC,

2825

What is the order of evaluation of the following operators + - * / ** () ???

2 4542

Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..

1 3429

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

HCL,

3 11266

how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too

CTS,

5 10687

How to change the order of prompts in universe?

3 11489

Un-Answered Questions { Data Warehouse }

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2058

what has been your most common programming mistake? : Sas programming

1120

Can you define drill down and drill up?

1040

How many input parameters can exist in an unconnected lookup?

1562

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1503

What is connection profile? : sas-grid-administration

1182

What is meta stage?

1189

Name some categories in sas 9? : sas-grid-administration

984

How will change port of obiee answers?

861

What is abap? What are idocs?

978

How can you differentiate between powercenter and power map?

1103

Explain how to generate iqd file from framework manager?

954

What are the themes in a data warehouse?

1056

What is decode in static cache?

1194

how are numeric and character missing values represented internally? : Sas programming

1156

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