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

how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 4386

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

IBM,

3 10584

what is executable in DataStage?

2 11065

How to Convert the columns into rows?

2 16533

how to convert rows into columns

IBM,

2 12181

How can i make use of Multiple Input Filter, the case is, i have two Datasources with different queries with a common field. i need the merge set in datarow of MultipleInputFilter. how can i make it.? please provide with clear example i'm new to actuate. thanks in advance.

2 5308

Can anyone explain me a scenario from banking and finance...more precisely a mapping

IBM,

2495

How to get top 5 rows of a selected column?

Patni,

3 9238

What r the type of indexes u generally used in informatica?

Keane India Ltd,

2 18984

What is the query to find nth highest salary? What is the use of cursors?

Keane India Ltd,

8 21188

explain about lookup t/r?

IBM,

1 4311

explain abt joiner t/r?

IBM,

1 4089

explain abt union t/r?

IBM,

1 4522

explain abt ur project architecture?

Anthem, DELL, IBM, TCS, Wipro,

2195

how do u fnd the duplicate rows and how to delete the duplicate rows?

IBM,

2 8279

Un-Answered Questions { Data Warehouse }

How do you delete duplicate observations in sas?

1074

How many types of hash files are there?

1185

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1058

-----------------What is Determination Model?

2140

What is fact table? Explain the different kinds of facts.

1076

What are the prerequisite tasks to achieve the session partition?

1252

Explain reference cursor?

2169

explain about sas business intelligence? : Sas-bi

1146

Why cognos decision stream is used?

1160

How can we improve the performance in datastage?

1105

Explain what is data step?

1205

EXL informatica Questions

1390

Can you define snapshot?

924

Where the applications and where

929

Tell me more about the parameters in macro? : sas-macro

1053

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