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 reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1944

What are the uses of query explorer? Give example for each use in detail. It is not given clearly in user guide so explain in detail.

1 5238

How can you link a query to a data container manually in Report Studio?

2369

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4597

can anybody explain me in detail about software development life cycle of business objects in detail?

1 5305

difference between imprompt and reportnwt1.1

HSBC,

2 5464

what are the features in cognos8ui

HSBC,

2067

how can you set the image in the report

HSBC,

1 6295

how can you create a project creation

HSBC,

2353

if there are list,crosstab,chart how can you apply a single filter to all object?

IBM, Syntel,

3 8736

what is the procedure for scheduling conditional rendering?

Syntel,

2538

what is dash board?

Syntel,

2 6328

what is field set? what is the query calculation and layout calculation?

Syntel,

2 16290

what is tabular set? how can you break the report?

Syntel,

1 6655

what are the types of facts ? explain them?

Business Objects, Informatica, Syntel, Teradata,

2 23272

Un-Answered Questions { Data Warehouse }

What is the SAS data set?

1148

Distinguish between informatica & datastage. Which one would you choose and why?

1020

What is primary and backup node?

1140

What are the fundamental blocks of co> operating system of ab initio?

1276

how to debug and test the sas program? : Sas-administrator

1049

Mention a few design and development best practices for informatica?

1009

What are the multiload utility limitations?

1074

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10201

What are the types of hashed files in data stage

1119

Explain absolute filter?

995

Is olap services sold as a separate product?

932

How can you define user defied event?

1040

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1916

Explain what does level of granularity of a fact table signify?

968

how to merge 2 crosstabs thans

2654

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