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

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1112

How to provide security in frame work manager for a query subject?

969

How to improve session performance in aggregator transformation?

993

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1028

What is a functional dependency f said to be minimal?

1083

How to eliminate duplicate rows from flat file?

953

How to generate the cubes in framework manager?

1056

What are target types on the server?

1006

What is difference between model & package?

1044

What is the difference between constraind base load ordering and target load plan?

1127

How to add a number to a macro variable?

1008

What is the difference between drill through and masterdetail reports?

1176

What is the difference between narmal load and bulk load?

1 1429

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

962

What is the use of tabular model, tabular sql, tabular reference in real time application?

977

Un-Answered Questions { Data Warehouse }

Under which circumstances, informatica server creates reject files?

1109

what happens if the info.server doesn't find the session parameter in the parameter file?

1964

Explain what are conformed dimensions?

1100

What is the different type of jobs in datastage?

994

what is the function of catx syntax? : Sas-administrator

1117

how to connect to a flatfile through ftp in informatica

14317

What is target load order?

1268

What is the use of having index on table?

1018

What are the ways to do a “table lookup” in sas?

1047

How to run a query in teradata?

1099

How to convert a numeric variable to a character variable?

1219

To import the flat file definition into the designer where should the flat file be placed?

1072

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

789

What are the different types of lookups in datastage?

1074

How many steps etl contains explain with example?

987

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