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 7421

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

HSBC, IBM, TCS,

3 24437

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

2 6648

how to restrict null values in webi report?

InfoStep,

2 29761

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

6 11214

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 9013

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

1 4967

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

1 6142

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

3 16194

All active transformations r passive or not?

7 11805

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

CTS,

8 30675

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

Chase, Cognizant, Deloitte,

3 28631

What is the term PIPELINE in informatica ?

Deloitte,

7 34454

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 34874

what is report studiio and how to start it?

2 5177

Un-Answered Questions { Data Warehouse }

What is broadcasting and replicate?

1189

how many types of viewers available in tm1?

What is sequence generator transformation in informatica?

1094

What is oltp?

988

What is the difference between group and associare?

1059

How to do unit testing in informatica? How to load data in informatica ?

1144

What is the use of cognos decision stream?

1107

What is normalization, first normal form, second normal form, third normal form?

989

how does sas handle missing values in formats? : Sas programming

1155

Tell me about MD5 functions in informatica

938

What is the syntax for case when statement?

1166

explain about various caches available in data integrator? : Sas-di

1074

what is data integration? : Sas-di

1133

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1739

What are the differences between a connected lookup and unconnected lookup?

1082

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