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

how to calculate sum(sal) with out using aggregator satge

HSBC,

3 9293

what are the all possible features supported modify stage?

2156

i have one file i saved in csv how can i take these file into framework manager

2092

how to connect two or more table with single source qualifier?

IBM,

4 20986

Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

TCS,

15 26142

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

IBM,

2508

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

TCS,

5 14377

HI, can anybody explain me how performence will decrease if we create objects using derived tables ?

2 5232

When we can use multiple sql statement for each measure? and multiple sql statement for each context?

2 14007

Can anybody explain me ? without creating the alias can we resolve the fantrap?

4 8535

Is it necessary to give joins to the aggrigate tables in the universe?

2 5316

On which column will you take primary index???

4 9022

how to import multiple flat files in to single target where there is no common column in the flat files

TCS,

2 7335

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 9615

is cognos 7 is better than cognos 8

TCS,

2176

Un-Answered Questions { Data Warehouse }

What do you mean by the overflow errors?

1380

what are the benefits of data integration? : Sas-di

1123

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

2277

what is the basic structure sas administrator? : Sas-administrator

1010

What is fact less fact table? Where you have used it in your project?

1022

name the different procedures within ti?

Explain vldb?

1046

Differentiate between format and informat? : sas-grid-administration

1075

How is the number of passes in a sql query significant in performance evaluation?

978

what are some differences between proc summary and proc means? : Sas programming

1147

What should I have in mind when building olap solution from scratch?

997

Explain what is a three tier data warehouse?

983

Describe stream connector?

1318

Can you explain the co>operating system’s processing model?

1118

Describe crosslist option in tables statement?

1232

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