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

Aborted in Phase 2 data acquistion completed in fastload?

2 5820

Fast Load Script is failed and error tables are available then how do you restart?

TCS,

3 15293

How do you Generate Sequence in Teradata?

TCS,

3 16184

How do you Generate sequence at the time of Display?

Infosys,

2 8458

There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?

IBM,

4 9230

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?

4 12907

Why Multiload does not supports USI and supports NUSI?

4 21691

what is the custome stage in datastage? how can we impliment that one? plz tell me

Accenture,

2374

How do we implement materialized view?when to use materialized view?

TCS,

1 7810

In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

Polaris,

2 18598

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

1 4232

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

Patni,

3 9652

In which situations we can use normal and sparse lookup stages

IBM,

4 15957

where to select code page option?

TCS,

2 7174

How to run the Teradata jobs in unix environment ???

IBM,

4 16868

Un-Answered Questions { Data Warehouse }

Define report item?

1191

Difference between cold fusion 5 and cold fusion mx 6?

1003

Explain what is the advantages data mining over traditional approaches?

1036

What could be a data source system?

1029

What is the good sas programming practices for processing large data sets?

1131

What is the sql query overwrite in source qualifier in informatica

1099

I have two universes created by two difference database can we join them in designer & report level? How

993

Can we create multiple integration service on single repository?

1199

What is Session and Batches?

1115

explain one complex mapping with logic? sales project?

6688

what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

4011

What is broadcasting and replicate?

1181

What is informatica etl tool?

1007

what do you mean by passthrough functions?

977

How many types of hash files are there?

1190

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