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 5921

what is mean of Meta data definistions?

IBM,

4 8004

What is namespace and what it holds?

IBM,

7 25815

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

8 19704

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

Thomson,

2 7647

How to initialize environment variables?

Infosys,

4 14018

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

ME,

4 25184

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

HCL, ME,

2 9064

how to call routines in stages?

ME,

3 9337

what is the definitions for Datawarehose and Datamart?

4 8146

what is the differeces between hash and modulus partition methods

TCS,

4 29096

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

HCL,

9 149064

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 7235

need for registering a repository server

1 4106

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 29401

Un-Answered Questions { Data Warehouse }

What is a difference between complete, stop and abort?

1097

To which project that prefix will set is to private project or public project or both?how and where to set?

1865

Define APT_CONFIG in Datastage?

1098

What are the some differences between 7.x and 8.x version of datastage?

1270

Explain what are the various file formats involved in reportnet?

955

In sas admin differentiate between roles and capabilities? : sas-grid-administration

1017

Your application mode has crashed. How would you run your i-server?

998

What are Dimensional table?

1076

how to perform single sign in cognos by using url?

1164

what is the primary data source for the wrs? : Sas-bi

1254

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1051

Explain translate function?

1218

What is the advantage of using shortcuts?

1200

What is a quality stage in datastage tool?

1090

Explain load alternative records / rows into multiple targets - informatica

1168

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