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

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

TCS, Wipro,

2169

why u need to publish the package?

IBM,

5 8354

how u create cubes in ur project

IBM,

2 6138

what is $$$$?

TCS,

2163

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

CTS,

4 10551

How to display all the duplicate records from the oracle Table?

IBM,

3 10145

how u publish the packages in framework manager

TCS,

3 7119

WHAT ARE THE DISTNICT VARIABLES?

2272

HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?

IBM, TCS,

4 8357

how can find maximum salary by using Remove duplicate stage?

IBM,

5 14739

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

TCS,

2 7862

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

L&T, TCS, UnitedHealth Group, Wipro,

8 18574

What are the associated ports in look up T/R.

IBM, Zensar,

5 25634

1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

IBM,

2151

what are the types of nodes

HCL, TCS,

4 25584

Un-Answered Questions { Data Warehouse }

What is the difference between %put and symbolgen? : sas-macro

1245

Difference between output_index and output_indexes in reformat

1301

What are some commonly used bteq scripts?

1022

Define bulk load mode?

What are the transformations that are not supported in mapplet?

1039

which features do you use to check the data validations and errors? : Sas-administrator

1062

What are the steps involved in designing a fact table?

895

What is etl process?

945

how does sas handle missing values in assignment statements? : Sas programming

1028

what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2373

what are input dataset and output dataset options? : Sas programming

1113

Explain sessions?

1075

Within a cursor, how would you update fields on the row just fetched?

1079

Can we create a Integration service without a Repository service and vice versa?

1221

What is the use of having index on table?

1007

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