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 4485

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 10758

what is executable in DataStage?

2 11251

How to Convert the columns into rows?

2 16678

how to convert rows into columns

IBM,

2 12359

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 5431

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

IBM,

1 2570

How to get top 5 rows of a selected column?

Patni,

3 9428

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

Keane India Ltd,

2 19119

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

Keane India Ltd,

8 21509

explain about lookup t/r?

IBM,

1 4415

explain abt joiner t/r?

IBM,

1 4212

explain abt union t/r?

IBM,

1 4615

explain abt ur project architecture?

Anthem, DELL, IBM, TCS, Wipro,

1 2254

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

IBM,

2 8425

Un-Answered Questions { Data Warehouse }

What is the purpose of Dataware Control?

1121

How to add default rules in transformer?

1284

What is the difference between business requirement document and use case document.

1083

Explain in detail about scd type 1 through mapping.

1646

Explain how to generate iqd file from framework manager?

1022

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1101

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1997

EXL informatica Questions

1461

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1197

Hi, If anyone has base SAS certification dumps, please share.

1938

Are you involved in writing the inferential analysis plan? Tables specifications?

4019

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2794

How do you remove duplicate records in informatica? And how many ways are there to do it?

1233

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6077

Demonstrate experience in maintaining quality process standards?

2672

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