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

2001

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 6266

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 7681

what is the difference between MOLAP and ROLAP?

3 8813

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 22135

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 12161

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 16017

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,

3346

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

JPMorgan Chase,

2 7398

Un-Answered Questions { Data Warehouse }

What do you mean by filter transformation?

950

how does sas handle missing values in assignment statements? : Sas programming

1020

What are the steps involved after the disk manager passes the request?

1119

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

927

What is quality stage?

987

Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

1077

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3572

What is zero-foot print?

1019

Highlight the points of differences between the database and user in Teradata.

1109

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1160

Can a dimension table contain numeric values?

1058

Do you view contain data?

935

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

953

what are the component of range? : Sas-bi

1097

What is the importance of the exception activity in datastage?

1073

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