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 one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/

4 7416

how to Explain a complex report at the time of interview ? please post the answer very urgent?

HSBC, IBM, TCS,

3 24433

Explain how data modeling is useful to cognos in daily life?

2 6639

how to restrict null values in webi report?

InfoStep,

2 29753

Hi any done business objects certification.i am expecting some help from them.

6 11207

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

Wipro,

3 9010

using of matric studio we can developed to scorecard ... what is the meaning by scorecords

1 4961

what is the different between primarykey and surrogated key.. why we are going for surrogatekey...

1 6136

what is the meaning of drill down and drill up in COGNOS 8BI

3 16185

All active transformations r passive or not?

7 11795

how to load only the first and last record of a flat file into the target?

CTS,

8 30654

What is checksum termnology in informatica? Where do you use it ?

Chase, Cognizant, Deloitte,

3 28620

What is the term PIPELINE in informatica ?

Deloitte,

7 34434

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

Deloitte,

15 34859

what is report studiio and how to start it?

2 5172

Un-Answered Questions { Data Warehouse }

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

1096

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2088

Explain the pipeline partition with real time example?

1153

How do you add a number to a macro variable? : sas-macro

1025

Can you brief about the Data warehouse project you worked on?

2389

How to elaborate powercenter integration service?

1148

What is etl process. How many steps etl contains explain with example?

970

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2056

What metadata importer can do in ab initio?

1237

What is drilling across?

1008

server hot-ws270 is connect to Repository B. What does it mean?

2579

What is core dimension?

1073

What is MODEL is Data mining world?

2628

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

972

Differentiate between Join, Merge and Lookup stage?

1106

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