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

DataStage Scenario based Interview Questions

1 16936

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

IBM,

1959

what is function of retain statment

PPD,

2042

Limitation of REPLACESTR. Is there any character limitation to it.

CTS,

1 4588

Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1952

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

CTS,

2 5123

Thanks to all people who are posting their comments...

CTS,

1 2687

In development project what is the process to follow for an etl developer from day1

1725

10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list  Rank  Running-count

Data Semantics,

1 3720

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

L&T,

2 5069

if i have a query as flat file how can we load data to target table

Tech Mahindra,

1401

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

CTS,

1620

The question was on time stamp. what is the difference between HH and HH24 when to use when.

Nationwide,

2060

Please let me know how to make Data masking in informatica..

1733

Please let me know how to make encryption and decryption with example?

1908

Un-Answered Questions { Data Warehouse }

What are the reasons for which business can trust the approach of data processing?

1188

What is meant by query override?

1062

What are data validation strategies for data mart validation after loading process?

1022

What are the types of facts in microstrategy?

1033

What kind of layouts does abinitio support?

1294

What are the approaches used by optimizer during execution plan?

911

What are the partitioning techniques available in link partitioner?

2280

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2156

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2525

What is a functional dependency f said to be minimal?

1068

Why we use repository connectivity?

986

If RDBMS is halted what will you do ?

2171

What are products of cognos?

978

------------------What is Inline Query?

2230

define sparse cube?

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