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

Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that

BirlaSoft,

3 9775

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?

6 9517

What is FILLER command in Teradata?

CTS, IBM,

9 32329

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 5466

what types of repositories we can create in informatica? in real time in which type of repository we will work on?

2 8107

Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.

TCS,

6 9919

advantages of cascade prompt ???

iFlex,

3 8763

These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?

IBM,

2 6941

what are versions of cognos from starting release to latest in the market?

IBM,

4 8779

what are the joins present in reportnet?which is most widely used?

IBM, Satyam,

2 6641

where exactly in dataware house a confirmed dimension can be created

Deloitte,

4 12872

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

2256

1 4770

Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....

3 7429

what is the difference between bpo and call centre?

American Solutions,

2 6234

Un-Answered Questions { Data Warehouse }

define drill through?

Explain amp in teradata?

1156

What is oltp?

1018

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2200

How to view every column and the columns contained in indexes in teradata?

1103

Difference between SAS STATA & SPSS?

1181

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1158

What are the steps required to kill the job in Datastage?

1271

How to create different types of templates?

1037

Whats the difference between informatica powercenter server, repositoryserver and repository?

1223

Explain difference between onrow and onread method?

941

Terminate Activity

1343

AWS Redshift is basically works on nodes and cluster and which of following option Redshift is based on?

What is SAS informats?

1168

What is Active Datawarehousing?

1064

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