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 is difference between force_error & force_abort? How to use in abinitio graph?

IBM, TCL,

2 10621

What is the best way of creating huge test feeds ? How to use in abinitio graph?

IBM, TCL,

1 4367

Can you read multiple input files using one input file component ? (Same DML) How to use in abinitio graph?

IBM, TCL,

3 13177

What is difference between API

CitiGroup, IBM, TCL,

2 11915

What is the significance of record required indicator of Join component ? How to use in abinitio graph?

IBM, TCL,

2 6462

What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?

IBM, TCL,

1 3599

When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?

IBM, TCL,

1 2512

Layout - L1*, L1 - What is the difference ? How to use in abinitio graph?

IBM, TCL,

1 7692

What is standard environment ? How to use in abinitio graph?

IBM, TCL,

1 7924

How we can remove temp files of a failed job if .rec is not available ? How to use in abinitio graph?

IBM, TCL,

2 8774

why Skew should always be 0 ? How to use in abinitio graph?

IBM, TCL,

1 7144

You can ask about different vector functions. How to use in abinitio graph?

IBM, TCL,

1 5633

What mpjret contains ? How to use in abinitio graph?

IBM, TCL,

2 6951

Can you use scan to generate sequence number ? How to use in abinitio graph?

IBM, TCL,

2 9133

How you can generate surrogate key? How to use in abinitio graph?

IBM, TCL, Torry Harris,

2 10924

Un-Answered Questions { Data Warehouse }

How do you remove duplicate records in informatica? And how many ways are there to do it?

1233

What is dimensional table? Explain the different dimensions.

1270

explain in detail about type 3?

1091

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1101

faq's on cognos

4113

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2267

EXL informatica Questions

1462

What is a rollup component? Explain about it.

1245

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

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

2213

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2825

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2334

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

2494

what are the names of the reports that you prepared?

1198

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 ?

2549

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