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

what is runtime variable?

TCS,

3 7425

which is better perfomancewise lookup or joiner and why?can anyone give example?

TCS,

6 12116

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

TCS,

2872

how to configure databases through datastage

2 12369

hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...

5 9696

How to delete first 3 rows & last 3 rows in target table in informatica

TetraSoft,

6 14834

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 9766

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

IBM,

2 7071

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

Cognizant, Flextronics,

3 7894

what is the size ur source like(file system or database)? how many record daily come u r banking project?

Cognizant, Flextronics,

2158

what are the challenge face in u r project?explain me

iGate, TCS,

1 3545

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

iGate,

3 6882

I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same

2 7581

How can you achieve scan using reformat ?

2 13230

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 5106

Un-Answered Questions { Data Warehouse }

What is usage analysis in datastage?

1321

Explain about Informatica server process that how it works relates to mapping variables?

1093

Explain multivalued dependency?

998

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

915

flat filevalidation in informatica

2166

What is a datastage job?

1026

Explain what is the difference between datawarehouse and bi?

984

What is the difference between odbc and drs stage?

1105

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1929

What are the different types of fact tables used in data warehousing?

1004

What are the different types of security you have worked in obiee?

800

Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

2051

Explain the Roles in mstr?

989

where to use sas business intelligence? : Sas-bi

1105

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

984

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