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

Can we update the data in flat file using update strategy?

3 16757

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

HCL,

2363

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

TCS,

2 6713

how many rows sorted in sort stage by default in server jobs

Syntel,

3997

what is the difference between aggregation and role up aggregation ?

Systime,

1 5118

Compare and contrast aggregates & indexes

IBM, TCS,

3777

Compare aggregates and data marts

TCS,

2766

what role views play in dimensional modeling?

TCS, Zensar,

1 5919

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

IBM,

1 5124

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 8236

I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?

CTS,

7 24608

how to define satge variables in transformer stage

2 22708

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

TCS,

3 10527

How to display errors in datastage?

TCS,

1 4036

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

1 17781

Un-Answered Questions { Data Warehouse }

can be used COM component in Informatica ?

2059

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1904

What is conduct>it?

1114

What are the names of the layers in etl?

1001

What is different between the data warehouse and data mart?

1066

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1086

When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

1152

How can bottlenecks be identified?

1018

Explain what is sort component in abinitio?

1104

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2156

How do you achieve schema object version control?

1002

How do you ensure simultaneous releases across multiple operating systems?

973

What is a data warehousing?

1156

What is pass through metrics in microstrategy?

978

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920

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