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 15431

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!!!

2253

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

TCS,

5 15608

How many macros we can create inside a macro

Wipro,

1 7010

what is identity columns in teradata

Wipro,

2 9545

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

Wipro,

2 7300

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

Wipro,

3 8379

what is identity columns in TD?

Wipro,

2 5825

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

CTS, Deloitte,

1 5831

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 10595

what is identity column in TD?

Wipro,

2 8098

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

IBM,

2338

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 3780

Hi, Lookup() is what kind of join ?

Satyam,

6 12449

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 12849

Un-Answered Questions { Data Warehouse }

What are the types of lookup transformation?

1125

How to Remove Duplicate using SQL?

1436

What is called materialized view?

1146

Can I deploy a single bi application in multiple languages?

1035

What is parallel processing in informatica?

1805

What are the steps involved in designing a fact table?

942

What is the benefit of session partitioning?

1161

Explain the scenario which compels informatica server to reject files?

1218

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2418

How are the dimension tables designed?

1053

If RDBMS is halted what will you do ?

2231

Explain reference cursor?

2235

Define update strategy?

1332

Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?

998

what is the use of skid in reporting?

2430

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