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 15298

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

2199

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

TCS,

5 15457

How many macros we can create inside a macro

Wipro,

1 6904

what is identity columns in teradata

Wipro,

2 9434

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

Wipro,

2 7181

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

Wipro,

3 8190

what is identity columns in TD?

Wipro,

2 5710

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

CTS, Deloitte,

1 5763

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 10448

what is identity column in TD?

Wipro,

2 7966

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

IBM,

2280

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 3721

Hi, Lookup() is what kind of join ?

Satyam,

6 12246

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 12677

Un-Answered Questions { Data Warehouse }

Explain a mapping, session, worklet, workflow, mapplet?

1120

How to identify ppi columns?

1196

What is abinitio?

1183

why is a stop statement needed for the point=option on a set statement? : Sas programming

1099

What is the limit to the number of sources and targets you can have in a mapping?

1115

Enlist the tasks for which source qualifier transformation is used.

1052

What is lookup transformation?

1054

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2516

I'm busy writing a report that's using report bursting, to be able to do this I need to use a sequential section. Using a sequential section cause the grouping of the original report not to work. Please can someone give me advise on how to come past this problem, the report need to use grouping as it depend largely on totals ect, and I need to use a sequential section within the report to be able to use the report bursting facility.

2787

How would you define the end of a macro?

1107

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2054

How to eliminate duplicate rows from flat file?

951

How to differentiate between the active and passive transformations?

1182

What’s the use of redshift?

What is substr function?

1200

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