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

how to unlock a locked job in datastage 8.0

3 23348

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

Cognizant, Wipro,

7 15341

hi, am put into Ab initio now. I need some material for to learn it!! i have to give a test also.. can anyone help me provide material please....

1 4938

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

Altisource, Patni,

1 9810

What is synonym?

Patni,

2 6067

what is lookup chache?

Patni,

1 4817

what is the mechanism of the Master-Detail joining condition?

IBM, Patni,

6 10213

Do joiner transformation use cache? If so describe?

Patni,

2 6963

what is materialized view?

2 5220

How will you check the bottle necks in informatica? From where do you start checking?

HCL,

3 7861

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

HCL,

8232

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3653

how to remove duplicates in transformer stage by using stage variables?one example?

Syntel, TCS,

6 33686

Can we Save (save as) WEBI Doc as DESKI?

HCL,

2 8193

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 5557

Un-Answered Questions { Data Warehouse }

What a static and local variable?

1086

Are you sensitive to code walk-throughs peer review or QC review?

3152

what are the other factors of the database on which the loading performance depend?

1918

What are the components of the workflow manager?

1147

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3578

what are the concerns of OLTP and DSS systems?

2458

When do we analyze the tables?

984

Explain what transformation and how many are there in informatica?

964

What is an unconnected transformation?

1098

How co>operating system integrates with legacy codes?

1184

What are shortcuts? Where it can be used? What are the advantages?

1079

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

995

How can you communicate with web server (apache or iis) from coldfusion?

1126

Where $mpjret is used in ab-initio?

1155

When do you use sql override in a lookup transformation?

1108

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