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

when we dont use aggregator in mapping ?

CSC,

2 6593

What r the existing server jobs in parallalism?

ITC Infotech,

2371

1.what is materialized data? 2.how to view the materialized data?

HCL, IBM,

2862

what is workflow varible

HP,

1 5946

In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha

TCS,

2173

hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.

2291

what is session parameters? what is use?

HCL, Satyam,

1 7024

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

IBM,

4 18360

If we set dd_insert in mapping and Delete in session properties what will happen.?

IBM,

4 8399

Is it possible to update the target table with PK?

TCS,

1 6435

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 5729

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 12665

When we go for OLAP , and When we go for OLTP for generating the reports ?

Honeywell,

3 9539

CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?

2437

how to read character value without using substr function in sas ?

3 9123

Un-Answered Questions { Data Warehouse }

How do you create surrogate key using ab initio?

996

If informatica has its scheduler why using third party scheduler?

1268

Is it possible to get a floating window in microstartegy web? If yes, how?

1161

how do u implement configuration management in Informatica?

4791

How sas treats the dsd delimiters?

1216

Explain the difference between the truncate and delete commands?

1167

how do you create schema objects in 2 tier connection?

953

How would you identify a macro variable?

1092

What are the different types of datawarehosuing?

993

What is the use of an aggregator cache file?

1199

What are the types of Data Warehouse applications?

1025

What is sq transformation?

1163

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1228

Mention some types of transformation?

1048

Describe the function and utility of the most difficult SAS macro that you have written?

2568

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