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 the end to end process meaning in my project(my project is development)and functionality plz tell me

2074

with out using update strategy transnsformation how to update the data in mapping level

1 4914

how to get the only updated records in the target

2 6377

how to get flatfile containg 10 records half records one target another half another target

2 5664

i'm searching on cognos..i want to know real time project explanation..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details for project and interview preparation..pls help me out..my mail-id is al.ramu@yahoo.com hope u will respond as soon as possible..thanks..

1 3280

what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance

IBM,

2 7812

what is the difference between MOLAP and ROLAP?

3 8945

I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 22395

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

Accenture,

6 12351

How to improve the session performance in informatica?

Accenture,

3 21661

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

2026

how to import XTP files into SAS datasets?

Barclays, Institute For Plasma Research,

1 8668

how to import HTML files into SAS datasets?

HP,

3 16189

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

JPMorgan Chase,

3409

how can or from where we can get reference data in scd type2 implementation?

JPMorgan Chase,

2 7505

Un-Answered Questions { Data Warehouse }

how does the server recongnise the source and target databases.Elaborate on this

2748

How can we run the graph? How can we schedule the graph in unix?

1007

Explain functional dependency?

1138

Tell me what is degree of a relation?

1059

How do you load only null records into target?

1258

What are teradata utilities?

1158

How to hide certain columns from a user?

894

What do you mean by fastexport in teradata?

1050

In abinitio, what types of parallelism are used?

1130

What do you mean by tpt in teradata?

1068

What is drill down and slicing and dicing whats the difference between them?

1160

How can we store previous session logs?

1141

How you can fix the truncated data error in datastage?

1890

Explain what is the difference between stop and abort?

1094

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2391

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