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

2000

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

1 4831

how to get the only updated records in the target

2 6264

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

2 5532

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 3168

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 7680

what is the difference between MOLAP and ROLAP?

3 8809

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 22132

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 12160

How to improve the session performance in informatica?

Accenture,

3 21524

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

1979

how to import XTP files into SAS datasets?

Barclays, Institute For Plasma Research,

1 8587

how to import HTML files into SAS datasets?

HP,

3 16013

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,

3345

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

JPMorgan Chase,

2 7391

Un-Answered Questions { Data Warehouse }

I need to set predefined condition. How I do this?

1014

Can you define report item?

1036

how to create reports on screech?

2553

explain in detail about type 3?

1013

Different circumstance which drives informatica server to expel records?

983

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1018

difference between repository database and repository service?

1150

What are the default statistics for means procedure?

1243

How to get sql from obiee for reports?

883

What is rank transformation?

991

How to performance tune reports?

1160

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2077

What is dimensional modeling?

1085

Can you define drill across?

980

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237

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