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

In a concurrent batch if a session fails, can you start again from that session

1 3140

When you move from devel to prod how will you retain a variable

1 3008

Partition, what happens if the specified key range is shorter and longer

Cap Gemini,

1 2586

Performance tuning( what you did in performance tuning)

Infosys,

1 2079

What are conformed dimensions?

1 3126

what are factless facts? And in which scenario will you use such kinds of fact tables.

1 1883

can you avoid static cache in the lookup transformation? I mean can you

1 3013

disable caching in a lookup transformation?

1 2552

In any project how many mappings they will use(minimum)?

1 3089

How do you implement unconn. Stored proc. In a mapping?

1 2862

Can you access a repository created in previous version of Informatica?

1 2799

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 2965

How big was your fact table

1 1894

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 3617

How will you convert rows into columns or columns into rows

1 2793

Un-Answered Questions { Data Warehouse }

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

848

faq's on cognos

4114

What is a rollup component? Explain about it.

1246

What is dimensional table? Explain the different dimensions.

1272

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1178

explain in detail about type 3?

1091

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1103

how to generate the test data in sas without input data? : Sas-administrator

1207

Have you have ever worked in unix environment and why it is useful in datastage?

1217

draw informatica architecture 8.6 ?

3949

Explain how to generate iqd file from framework manager?

1022

Demonstrate experience in maintaining quality process standards?

2676

What is the purpose of Dataware Control?

1121

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1202

what are the data modeling tools you have used?(polaris)

2060

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