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 9181

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 9781

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 6515

what is the different between link and join ?

2 5543

what is requery in cognos?

HMN, Satyam, TCS,

2539

What is APT_DUMP_SCORE?

IBM,

2 19276

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 11346

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

6 11070

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 6450

How to publish a package by running Java Script?

2137

how to remove the duplicates by proc sql?

Genpact,

2 9528

How we can convert rows to columns in datastage?

IBM,

4 25304

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 7737

how to delete the duplicates by using proc sql?

Genpact,

3 9185

what is the difference between proc means and proc summary?

Accenture,

2 7794

Un-Answered Questions { Data Warehouse }

what is the difference between nodup and nodupkey options? : Sas programming

1276

What is difference between webi and infoview?

1337

What are the different types of schemas used in data warehousing?

993

What is the difference between formal and export parameter? Export at what secenario we are going to use?

2681

What are the two types of framework manager?

1440

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2245

Explain in detail about type 1?

1832

What is the difference between Datawarehouse and OLAP?

977

Define report item?

1256

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

1042

What is defined as Cognos Impromptu?

1131

Can you explain surrogate key?

1104

how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2162

Explain the types of join supports by teradata?

1047

What is the difference between fastload and multiload? Which one is faster?

1302

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