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 6594

What r the existing server jobs in parallalism?

ITC Infotech,

2373

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

HCL, IBM,

2862

what is workflow varible

HP,

1 5947

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 7027

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

IBM,

4 18366

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

IBM,

4 8405

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 5734

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

6 12673

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

Honeywell,

3 9542

CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?

2440

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

3 9130

Un-Answered Questions { Data Warehouse }

what is the use of sas management console? : Sas-di

1098

What is the difference between static cache and dynamic cache?

998

Mention the difference between ceil and floor functions in sas?

1157

How to reverse the string using unix?

3515

Describe a data warehouse.

989

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3842

What is a folder? Difference types of stages?

1178

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2424

How to do the error handling of if ur source is flatfiles?

1968

How do we load data into Redshift?

what is the project environment(for each project the environment is same or different to different project)?

2227

is there any difference between operational database and data base?if yes what r they?

2066

Explain parsing engine in teradata?

1096

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

2187

When tpump is used instead of multiload?

1105

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