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

I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.

L&T,

2 6845

How will solve a loop caused by lookup table without using alias?

L&T,

1 6430

what are the all possible reasons of getting partial result on a webi report?

L&T,

3 11502

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?

Bank Of America, Wipro,

6 50342

Hi friends, I have 100 records in my input file, if i run first,the first 10 records are stored into the output and if i run second time next 10 records stored into the output file like that please let me know the answer Thanks, krishna

CTS,

5 25440

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

CTS, TCS,

2804

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 6124

I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?

2 5103

Why Star Schema is de-normalized? Please explain in detail probably with some examples.

DELL,

2 8284

How to create a Left Outer Join in FM? Please explain.

Cisco,

2 8039

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

HCL,

4 8915

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1953

i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers

SAS,

3 7090

How to make alternative rows red and green in WebI Report?

Accenture, Mphasis,

3 11306

How to restrict password to a user while sending a document in .pdf format

Mphasis,

2346

Un-Answered Questions { Data Warehouse }

Describe the ways in which you can create macro variables? : sas-macro

1067

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2060

I generated one report design time I can color green. At run I want bule how to change dynamically? And which method I can over write?

986

Difference between cold fusion 5 and cold fusion mx 6?

996

What is type 2 version dimension?

974

how many users can open or connect to one of the tm1 web application concurrently?

What is prompt types of prompts?use of prompts syntax of prompt?

1345

how you can enable bulk load mode in ti?

How we can use union transformation?

1051

Explain pushdown optimization $pushdownconfig parameter - informatica

1147

Explain why denormalization is promoted in universe designing?

961

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1807

Describe what the SQL Server tempdb and tlog files are used for?

2340

Can you define metrics designer?

1057

What is the purpose of having stored procedures in a database?

1152

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