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

data stores in which location while using data set stage as the target?

IBM, TCS,

1 7527

How to Join Tables my Source is having 15 table target is one?

TCS,

4 8323

what is snow flack schema?

2 6536

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

TCS,

2 7886

Can we use unconnected lookup as dynamic lookup?

ITC Infotech, TCS, Wipro,

5 17910

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 4266

1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?

Cognizant,

2 8552

how did u understand business requirement?

TCS,

2 5973

what is hybrid schema

TCS,

4 16845

What is the difference b/w the simple Universe and Complex Universe?

2 7620

Aliases and Contexts Which once will give the better performence when resolve the loops?

HCL,

3 9102

What is meant by multiple data provider.How to use it in universe as well as reporting environment?

TCS,

6 12098

if the project is assigned for you and the client said yo wait for a month,What will you do in that time?

1 4026

What is meant by data federator and what is the use of it?

TCS,

2 7936

What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...

TCS,

1 3743

Un-Answered Questions { Data Warehouse }

what are the names of the reports that you prepared?

1199

Write the unconnected lookup syntax?

1153

Demonstrate experience in maintaining quality process standards?

2676

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2127

faq's on cognos

4114

How to add default rules in transformer?

1288

Explain in detail about scd type 1 through mapping.

1648

What are the data types present in bo? What happens if we implement view in the designer and report?

1082

What r the names of the reports that you prepared?

1032

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2067

Have you have ever worked in unix environment and why it is useful in datastage?

1217

Explain how to generate iqd file from framework manager?

1022

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2153

What is rollup component?

1341

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2266

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