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 meant header and tailer, suppose header and tailer had some junk data how will delete junk data ? which components r used?

5 14152

what is hash file in abinitio? how will it read in abinitio? in hash file the data files r combine (file1.dat,file2.dat,file3.dat......etc) how will it divide?

HP,

2 15325

what is decoding & what is NVL?

1 10744

how will i can implemate Insert,Update,delete in abinitio? how will u view MFS in unix?what is diff/btween conditional dml& conditional component?

IBM, Syntel,

3 31511

can we create index and drop index in exsisting table while using infomatica

4 20184

"Change cache" in Informatica ?

2 7740

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 16182

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 19527

What is the difference between Proc tabulate and Proc print

CitiGroup,

4 13201

How to convert a given date value into SAS date

CitiGroup, Quintiles,

9 39372

I want to do on drill calculation? Actually My report is like Continent Amount(Global Currency in dollar) ASIA 200 UK 100 On Drill ASIA Country Amount INDIA 5712(120*47.6) SINGAPORE 128(80 * 1.6) On Drill INDIA State Amount DELHI 3712 CHENNAI 2000

2 5089

What is Universe?

1 5080

What is Designer?

2 5109

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2506

Can any one tell me cognos training class in chennai? thanks in advance...

5 7863

Un-Answered Questions { Data Warehouse }

What are all types of Batches?

1079

Describe the impact of several join conditions and join order in a joiner transformation?

1117

What is freehand sql?

1102

Explain security role?

1000

what are the data modeling tools you have used?(polaris)

2051

difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2882

What is workflow? What are the components of workflow manager?

1235

How the users created differs from rpd/answers/dashboards level?

853

What we will do with the universe for faster process?

1036

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7598

Whats the difference between informatica powercenter server, repositoryserver and repository?

1223

What do you mean by Drill down and Drill Up?

1055

Explain normalization?

1207

What is MODEL is Data mining world?

2665

8. How much supervision have you typically received in your previous job?

2317

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