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 11730

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 6211

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

CSC, HCL,

2 8266

What is the size of PDV?

L&T,

2 13629

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 15453

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

Accenture,

2 9610

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

CTS,

5 9006

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

3637

How many ways to overcome a missing values???

HSBC,

2827

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

2 4551

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

1 3437

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 11276

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 10693

How to change the order of prompts in universe?

3 11494

Un-Answered Questions { Data Warehouse }

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4334

What are public objects?

1067

What is write-back in obiee ?

841

How do you reject records in a transformer?

1136

hi real timers . iam waiting for ur reply regarding ETL TESTING

2284

Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

2098

How many tables can you join in v2r5?

1085

what is 'reconsideration error' and how can i respond to this error and how to debug this

2637

Explain what is the data type of the surrogate key?

987

What do mean by local and global repository?

1237

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1110

if collect stats but it show low confidence why?

1708

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1182

how do u set partition points in the mapping?

2608

what is the -ve test case in your project.

2428

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