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 19624

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 13335

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

1 12543

Why do we create shortcuts in framework manager

4 19272

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

BoA, Quintiles,

2 7261

How do i read multiple spaces in datasets?

Quintiles,

4 8990

What is use of Field Set present in toolbox?

1 15884

Diff b/w ShortCut and reusabel Object ?

4 8633

What are the ETL tools available in DWH?

Mphasis,

6 15501

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 12751

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 12091

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 7028

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

2 8284

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

3 24035

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 6981

Un-Answered Questions { Data Warehouse }

Explain the ab initio etl tool in high level?

1209

What are vldb properties in microstrategy?

1116

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

2748

What is the function you would use to transfer a string into a decimal?

1284

how do you debug and test your sas programs? : Sas programming

1174

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4791

How to run a graph infinitely?

1163

What Proc glm does?

1147

What is the use of %include statement?

1108

what is the difference between cubes and package in cognos

5005

What is workflow manager?

1106

What is run-group processing?

1247

what is the role of transformer?

What are the various etl tools in the market?

1126

Comment whether bottleneck is an error or not.

1225

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