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 6865

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

L&T,

1 6455

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

L&T,

3 11531

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 50391

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 25468

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

CTS, TCS,

2812

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 6144

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 5128

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

DELL,

2 8308

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

Cisco,

2 8062

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 8933

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?

1964

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 7111

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

Accenture, Mphasis,

3 11335

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

Mphasis,

2356

Un-Answered Questions { Data Warehouse }

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2877

What’s the use of redshift?

Where can we find the throughput option in informatica?

1075

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2011

-------------How you design DWH?

2323

Explain when do we analyze the tables? How do we do it?

1008

What does P-value signify about the statistical data?

1374

How to connect a private redshift cluster?

How analytics process your request when you create your requests?

942

Describe the function and untility of the most difficult SAS macro that you have written.

2133

Can you define a catalog and types of catalogs in cognos?

1067

What is the difference between Active and Passive transformation?

1169

What is the difference between dml expression and xfr expression?

1113

What are the key features of chameleon that separates it from other algorithms?

1128

What sort of existing documents should business analysts refer to when starting on a new project?

1016

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