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

PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?

7 30290

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me

2415

Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?

CSC,

2 6303

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want

3 7916

What is Grain & Granularity in Data Warehouse.

TCS, TVS,

2 46238

What is the Difference Between DataStage 7.5 version and 8.1 Version?

IBM,

10 69059

what is the Difference Between Datastage Server Edition and Parallel Edition?

Tech Mahindra,

2 10504

what is datamart

IBM, Informatica,

4 7881

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

HCL,

4 13739

what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?

2 19703

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

TCS,

2 5713

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

TCS,

4 13906

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

TCS,

5 10446

what is view filter

IBM, Marlabs, Ness Technologies,

9 12668

wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container

2393

Un-Answered Questions { Data Warehouse }

Is possible to create skid in dim,fact tables?

2636

how do u really know that paging to disk is happening while u are using a lookup transform?

1983

What are the different types of partition components in abinitio?

1348

What are the different types of segments?

991

What is meant by a domain?

1127

What is a general purpose scheduling tool?

1113

What are the methods by which it non-durable model could be changed into the durable model?

958

What are the kinds of layouts does ab initio supports?

1000

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1100

how do u extract data from different data sources explain with an example?

2244

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

2124

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2184

What is meant by a Virtual Disk?

1136

What are the types of dimensional modeling?

1063

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1106

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