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

Use of Text Source Variable in Report Studio?

2 19514

There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?

5 13126

How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

1 12445

Why do we create shortcuts in framework manager

4 19081

How to do user inputs and command line arguments in SAS? D&B

BoA, Quintiles,

2 7143

How do i read multiple spaces in datasets?

Quintiles,

4 8842

What is use of Field Set present in toolbox?

1 15790

Diff b/w ShortCut and reusabel Object ?

4 8462

What are the ETL tools available in DWH?

Mphasis,

6 15304

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

TCS,

5 12555

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

iGate,

5 11934

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

iGate,

1 6937

how to perform paired t-test using Base/SAS & SAS/Stat?

2 8169

What is the difference between Regression and Logistic Regression? Can u explain the Assumptions/Conditions?

3 23927

When a report in Web intelligence is created with ten objects and save the same as PDF the report divides the report into two pages. One page with data for five objects and the other with next five objects? Is there a way to combine these ten columns in a single page view?

2 6882

Un-Answered Questions { Data Warehouse }

What is a real-time data warehouse?

998

For what purpose would you use the RETAIN statement?

1524

How is union transformation utilized?

1009

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

2019

How can we improve session performance in aggregator transformation?

1117

Name the different lookup cache(s)?

1235

Plz can any one say me how to get the informatica certification materials and dumps

2050

Can we create a Integration service without a Repository service and vice versa?

1215

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2003

What are report caches and how many types are there?

972

what is Forward,Reverse and Re_engineering?

2196

What is metadata in context of a datawarehouse?

1060

Difference between project merge and object manager in microstrategy?

995

Write different kinds of objects in microstrategy?

1003

How do you load unique records into one target table and duplicate records into a different target table?

1261

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