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

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

Wipro,

3 9065

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

Wipro,

2 9659

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

Wipro,

2 6421

what is the different between link and join ?

2 5431

what is requery in cognos?

HMN, Satyam, TCS,

2484

What is APT_DUMP_SCORE?

IBM,

2 19126

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

HP,

8 11073

what is mean by flag 4 in update strategy t/r

6 10863

how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

Patni,

2 6338

How to publish a package by running Java Script?

2086

how to remove the duplicates by proc sql?

Genpact,

2 9397

How we can convert rows to columns in datastage?

IBM,

4 25095

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 7592

how to delete the duplicates by using proc sql?

Genpact,

3 9040

what is the difference between proc means and proc summary?

Accenture,

2 7668

Un-Answered Questions { Data Warehouse }

differentiate between power play transformer and power play reports?

What is a transaction control transformation?

1209

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1345

What are the different modes to run i-server?

1066

explain in detail about type 3?

1014

According to you, what are the most important tables in a dw? Why?

986

client know skid info?

2084

what are the names of the reports that you prepared?

1107

Describe the main features of datastage?

1076

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

1167

What is the difference between regular dimension and derminant?

2275

3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2623

What is the differentiate between data file and descriptor file?

1363

What is a rollup component?

1137

What is the difference between operational data stage (ods) and data warehouse?

1243

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