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 7590

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

HSBC, IBM, TCS,

3 24629

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

2 6840

how to restrict null values in webi report?

InfoStep,

2 29885

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

6 11464

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 9160

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

1 5063

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

1 6271

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

3 16331

All active transformations r passive or not?

7 12046

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

CTS,

8 31048

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

Chase, Cognizant, Deloitte,

3 28820

What is the term PIPELINE in informatica ?

Deloitte,

7 34763

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 35471

what is report studiio and how to start it?

2 5259

Un-Answered Questions { Data Warehouse }

What is aggregate table and aggregate fact table ... Any examples of both?

1119

What is node? How many nodes and amps used in your previous project?

1178

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

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

2313

Explain scd type 3 through mapping.

1076

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

4192

Write the unconnected lookup syntax?

1152

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2494

what are the dimensions that you have in your current project?list them?

2095

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

2066

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2107

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 how to generate iqd file from framework manager?

1022

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2344

Explain in detail about scd type 1 through mapping.

1646

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