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 11985

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 6325

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

CSC, HCL,

2 8376

What is the size of PDV?

L&T,

2 13770

Define Dynamic push down optmization?

HP,

1 2374

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 15842

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

Accenture,

2 9804

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

CTS,

5 9277

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

1 3733

How many ways to overcome a missing values???

HSBC,

1 2899

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

2 4662

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

1 3508

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 11436

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 10883

How to change the order of prompts in universe?

3 11675

Un-Answered Questions { Data Warehouse }

What is the difference between business requirement document and use case document.

1086

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1853

Hi friends, what are the new features in abinito3.0?

2860

How do you remove duplicate records in informatica? And how many ways are there to do it?

1237

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1245

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2495

How to add default rules in transformer?

1288

Explain about a time when you discovered a more efficient way to do a work task?

1224

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6082

What are the data types present in bo? What happens if we implement view in the designer and report?

1082

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2153

how to generate the test data in sas without input data? : Sas-administrator

1207

Explain in detail about scd type 1 through mapping.

1648

Explain about a tricky situation for which you found a very simple solution?

1081

Hi, If anyone has base SAS certification dumps, please share.

1943

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