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

how can we use sorter transformation in joins?

IBM,

5 17993

Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?

1 4352

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2347

What are symbol tables?Differemce between Local N Global Symbol tables.....

TCS,

2 10441

In which format does Date stores in sas..? What is the use of DATE in SAS.?

TCS,

3 9579

One way of creating a new variable in Macros is by % Let....What is the other way..?

TCS,

5 10895

What are the functions done while Compilation...?

TCS,

1 6308

What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?

TCS,

3 9170

What is difference between Global n Local Macro Variables..?

TCS,

6 28016

What is Transaction...? And what are Comment, Roll back n Save point..?

2 6923

Explain the Difference Between Bursting and Scheduling?

1 17925

any body can say about all versions of informatica ?how many versions ?

2 9977

if ename='subbu' while running job the job should be abort how come?

IBM,

3 8662

how to find diff between 2 dates without using Icon... funtions?

1 3659

how to find no.of records in sequntial file itself?

4 21690

Un-Answered Questions { Data Warehouse }

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

966

Differentiate between joiner and lookup transformation?

1105

flat filevalidation in informatica

2158

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

907

What does edp stand for?

1165

define query subject?

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1172

What is core dimension?

1067

Explain me what are conformed dimensions?

1036

How do dates work in sas?

1147

Explain the hierarchies level data warehousing.

889

Why are meta service important then other services?

975

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1170

Define Merge?

1324

What is a conditional attribute in microstrategy?

1108

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