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 5906

what is mean of Meta data definistions?

IBM,

4 7976

What is namespace and what it holds?

IBM,

7 25782

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

8 19676

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

Thomson,

2 7625

How to initialize environment variables?

Infosys,

4 13982

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

ME,

4 25151

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

HCL, ME,

2 9050

how to call routines in stages?

ME,

3 9316

what is the definitions for Datawarehose and Datamart?

4 8116

what is the differeces between hash and modulus partition methods

TCS,

4 29060

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

HCL,

9 148998

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 7214

need for registering a repository server

1 4091

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 29340

Un-Answered Questions { Data Warehouse }

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

975

What is workflow? What are the components of workflow manager?

1178

what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?

951

what is the use of server manager?

2137

How do you set the session mode parameters in bteq?

1106

What is the difference between partitioning with key / hash and round robin?

1382

tell me 5 session failure in real time how can you solve that in your project?

2305

Are you involved in writing the inferential analysis plan? Tables specifications?

3960

What is the method of removing duplicates, without the remove duplicate stage?

1027

You have got the requirement from a client. Explain the technical approach you will take now.

974

what is the difference steps for data modeling?

2598

Compare cold fusion with other programming languages?

1008

Briefly explain input and put function?

1085

What system options would you use to help debug a macro? : sas-macro

1097

What are the functions of a Parser?

1114

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