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 we send repotrts/documents to end user

HP,

2 7484

what is universe testing(not mention check integrity)

1 5066

in xir2 how to send reports to end user

TCS,

2 7117

How do you deployment reports from one server (Development) to other server(Production)? How do you configure the cognos7.0 version cube in cognos 8.0? Pls, explain with example? How do you create IQD without IMR or can u explain other way create IQD?

TCS,

2 9402

how we improve the performance of report and universe?

Accenture, IBM,

4 15363

I have a report with n number of records. i want to take alternative rows as a red in color. How to make it?

Keane India Ltd,

4 8988

i want to take a report 10 records per page. How to take it? is there any paging option in BO?

Cap Gemini, IBM,

5 13205

What is ment by For each For all function. In which case we use the option in BO?

IBM, TCS,

2 15307

can a port in expression transf be given the name DISTINCT

3 13559

how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

HCL,

2106

In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.

5 9836

What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?

3 10248

what is the difference between aggregation and roll up aggregation?

1 7064

Difference between cognos report net and cognos8

1 6651

Difference betwween cognos report net architecture and cognos8 architecture

3 12794

Un-Answered Questions { Data Warehouse }

What is an active transformation?

1119

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2868

What is surrogate key? Where we use it?

1006

Explain informatica architecture - version 8 / 9

1103

Explain input and put function?

1149

What are data elements?

1184

Explain meta data?

1043

what is session partitioning?

2152

How to import vsam files from source to target. Do we need a special plugin?

942

what is guided navigation?

913

what is ds administrator used for?

1184

What is the use of teradata system software?

1045

What are the data types that sas contain?

1199

name the different procedures within ti?

How to create the source and target database connections in server manager?

1102

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