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

When we use consume in cognos?

IBM,

1 5977

what is mean of Meta data definistions?

IBM,

4 8177

What is namespace and what it holds?

IBM,

7 26072

What is the "junk dimension"? Give with examples?

8 19934

what is a hot file, why we need in datawarehousing, where we used in general

Thomson,

2 7742

How to initialize environment variables?

Infosys,

4 14227

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

ME,

4 25343

How to create environments and call them? What is the use defined variables?

HCL, ME,

2 9156

how to call routines in stages?

ME,

3 9493

what is the definitions for Datawarehose and Datamart?

4 8285

what is the differeces between hash and modulus partition methods

TCS,

4 29325

what is the main differences between Lookup, Join and Merge stages?

HCL,

9 149350

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 7379

need for registering a repository server

1 4172

I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.

13 29837

Un-Answered Questions { Data Warehouse }

-------------What is Coditional Prompting?

2234

Explain difference between snow flake and star schema.

1127

Explain parsing engine in teradata?

1150

Explain what are the various file formats involved in reportnet?

1038

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1267

Why union transformation is an active transformation?

1109

How do you improve the performance of the Cognos Analytics report

1114

Why do you get spool space errors? How do trouble-shoot them?

1103

Explain what are components of reportnet?

1035

how u will determine the performence tune will occur either in report or system

2190

What are the different types of data warehouses?

1149

what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1300

What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

1259

what are the features in cognos8ui

2108

how to remove duplicates using proc sql?

1208

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