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 30298

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 6304

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 7918

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 69067

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

Tech Mahindra,

2 10508

what is datamart

IBM, Informatica,

4 7882

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 13740

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 5715

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 10448

what is view filter

IBM, Marlabs, Ness Technologies,

9 12675

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

2396

Un-Answered Questions { Data Warehouse }

Have you used Unstructured data?

1321

What is difference between page break and section report?

1209

What is the difference between fastload and multiload? Which one is faster?

1223

What are the vldb properties? Which level of vldb configurations have the highest precedence?

944

What is the use of datastage designer?

1154

Explain and compare pros and cons of snow flake schemas?

1035

In Datastage, how you can fix the truncated data error?

1161

Explain transformations?

1010

Can sorting and storing be done through single software or you need different for these approaches?

1118

While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?

927

Explain the difference between filter and conditin?

965

Are you involved in writing the inferential analysis plan? Tables specifications?

3960

Explain the different dimensions.

967

what are informats in sas? : Sas-administrator

1093

What is called Cognos powerplay?

1083

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