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 16785

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,

2380

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 6731

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

Syntel,

4007

what is the difference between aggregation and role up aggregation ?

Systime,

1 5130

Compare and contrast aggregates & indexes

IBM, TCS,

3786

Compare aggregates and data marts

TCS,

2776

what role views play in dimensional modeling?

TCS, Zensar,

1 5930

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 5134

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 8258

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 24663

how to define satge variables in transformer stage

2 22727

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

TCS,

3 10546

How to display errors in datastage?

TCS,

1 4053

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 17807

Un-Answered Questions { Data Warehouse }

hoe to access second value in mapping parameter if it is having more than one value ?????????????

1553

how to explain health care project and which reports we can create in health care doain?

6812

how do u set partition points in the mapping?

2252

What is the difference between regular dimension and derminant?

2286

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

1153

What is factless fact tables?

1221

Explain what are the different types of join operations?

986

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2134

What are the functions of the replicate and dedup component?

1106

what is SDLC way of code development?

2050

Have you created hierarchy in obiee. If so where and how?

897

How we can use union transformation?

1068

Do you view contain data?

952

Can you define a query subject?

1028

What are the parameters of scan function?

1189

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