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 10623

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 13183

What is difference between API

CitiGroup, IBM, TCL,

2 11917

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 3602

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

IBM, TCL,

1 2516

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 7929

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

IBM, TCL,

2 8778

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 5639

What mpjret contains ? How to use in abinitio graph?

IBM, TCL,

2 6952

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

IBM, TCL,

2 9135

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

IBM, TCL, Torry Harris,

2 10927

Un-Answered Questions { Data Warehouse }

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1964

How to create the source and target database connections in server manager?

1144

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

1202

Explain about a time when you discovered a more efficient way to do a work task?

1224

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2268

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

2346

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

1236

explain in detail about type 3?

1093

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

What is a rollup component? Explain about it.

1246

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

2108

what are the names of the reports that you prepared?

1201

how many reports have u created ? explain a few.

2162

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1245

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2177

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