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

why we use aggregation in lower level

TCS,

1 5613

draw the architecture of bo

IBM,

3339

u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources

IBM,

4 8952

what is mean by grouping of condition column in lookup transformation?

1 6651

how to explain a project to the interviewer on sales project and what r the basics to be prepared to attend a interview

IBM,

2 6697

How can we do the unit testing?

Logica CMG,

3 12897

DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.

Verinon Technology Solutions,

8 10658

can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.

3 7475

Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

SingleTusk,

1 2064

what is galaxy repository?

2 16936

task is running successfully but data is not loded why?

2 7524

what is the difference between Informatica7.1 & informatica 8.1

4 9643

whats the Diffrerence between business objects and cognos?

1 5446

what r the advantages of creating the universe?

2 7438

define universe parameters?

5 10607

Un-Answered Questions { Data Warehouse }

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

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.

1244

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

1082

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

1174

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2795

Explain in detail about scd type 1 through mapping.

1646

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2303

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1044

What is rollup component?

1337

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4192

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..

1964

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6077

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

1940

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3664

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

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