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

Difference between Force_error & Force_abort?

2 15265

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2193

Can we create out put ports in source qualifier t/r?

TCS,

5 15414

How many macros we can create inside a macro

Wipro,

1 6875

what is identity columns in teradata

Wipro,

2 9415

what is referential constraints?how do you implement RI in teradata?

Wipro,

2 7157

What is Difference b/w PI & PPI?how to implement PPI?

Wipro,

3 8155

what is identity columns in TD?

Wipro,

2 5685

if a error occured in FASTLOAD is the fastload job stops?

CTS, Deloitte,

1 5745

sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

CTS,

3 10418

what is identity column in TD?

Wipro,

2 7945

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

IBM,

2261

Hi All.I am looking for Good Institute who could Provide the online SAS BI+DI Training along with software.Primarily in Delhi/NCR or in Hyderabad Please help with name and contact number of concerned person!! Thanks in Advance! :)

1 3695

Hi, Lookup() is what kind of join ?

Satyam,

6 12213

create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;

WNS,

6 12633

Un-Answered Questions { Data Warehouse }

What are active transformations.

1654

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

2185

what is pmrep command?

11578

Explain the data types present in bo and what happens if we implement view in the designer and report?

1029

In sas admin differentiate between roles and capabilities? : sas-grid-administration

1003

What is microstrategy desktop?

1028

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2500

What is a rollup component?

1137

what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1239

What is thumbnail?

969

Differentiate between proc means and proc summary.

1062

What is the dense rank?

1231

Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1260

Explain grouped cross tab?

2626

Explain what is the difference between view filter and report filter?

978

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