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

What are active transformations? Name them.

1 2720

Can you use flat files in Mapplets.

1 2744

How many transformations can be used in mapplets.

1 2009

Can a joiner be used in a mapplet.

1 4218

What are active transformations.

1 1721

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 2939

Global and Local shortcuts. Advantages.

1 2120

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 2897

Have you worked with/created Parameter file

1 1740

What's the layout of parameter file (what does a parameter file contain?)?

Cognizant,

1 2451

Why do you use Mapping Parameter and mapping variable?

1 1843

Where do you create/define mapping parameter and mapping variable?

1 3440

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

IBM,

1 3843

Slowly changing dimensions, types and where will you use them

1 1798

What are the modules in Power Center

1 1743

Un-Answered Questions { Data Warehouse }

how to generate the test data in sas without input data? : Sas-administrator

1207

draw informatica architecture 8.6 ?

3949

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

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

2495

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

1179

Explain how to generate iqd file from framework manager?

1022

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

6079

what is document design in boxi,have u participate in that

2308

faq's on cognos

4114

Write the unconnected lookup syntax?

1153

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

2068

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1202

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

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2550

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2214

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