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 4393

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 10604

what is executable in DataStage?

2 11076

How to Convert the columns into rows?

2 16545

how to convert rows into columns

IBM,

2 12197

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 5326

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

IBM,

2508

How to get top 5 rows of a selected column?

Patni,

3 9262

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

Keane India Ltd,

2 18997

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

Keane India Ltd,

8 21218

explain about lookup t/r?

IBM,

1 4326

explain abt joiner t/r?

IBM,

1 4100

explain abt union t/r?

IBM,

1 4532

explain abt ur project architecture?

Anthem, DELL, IBM, TCS, Wipro,

2201

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

IBM,

2 8289

Un-Answered Questions { Data Warehouse }

Explain when we use aggregate awareness function in designer?

1041

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1067

Can you define folder?

974

What needs to be done when the database is shutdown?

1032

What is the surrogate key?

1276

What all are the different way to run a job?

1100

How to do unit testing in informatica?

1190

Explain what is batch and describe about types of batches?

1087

Write various indexes used in cognos?

978

If RDBMS is halted what will you do ?

2179

what is session partitioning?

2152

what is the difference between querystudio in reportnet and cognos8

2145

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7414

What is cognos reporting tool?

1100

define the logic behind the sparsity in cubes?

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