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 many universes can be created in a project?

1 1114

Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1 1107

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1 1405

How to generate the report from excel sheet?

1 1269

Explain how we drill up week to month?

1 1165

Is there any other repository domains rather than universe, security, document?

1 1107

What is the dense rank?

1 1357

What are all difference between business objects 6.5 and xi r2?

1 1103

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1 1170

What are the steps to be taken to schedule the report?

1 1023

Explain when to use local filter and when to use global filter?

1 1418

What is a fantrap in business objects?

1 1244

Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

1 1086

What is report template in b.o?

1 1090

What is difference between custom hierarchy and report based hierarchy?

1 1085

Un-Answered Questions { Data Warehouse }

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2084

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3441

How do you remove duplicate records in informatica? And how many ways are there to do it?

1231

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1237

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2310

Hi, If anyone has base SAS certification dumps, please share.

1936

What is rollup component?

1330

what are the data modeling tools you have used?(polaris)

2057

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

1213

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1961

Demonstrate experience in maintaining quality process standards?

2670

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1196

Write the unconnected lookup syntax and how to return more than one column.

1174

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

845

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