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 15262

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 15410

How many macros we can create inside a macro

Wipro,

1 6874

what is identity columns in teradata

Wipro,

2 9412

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

Wipro,

2 7154

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

Wipro,

3 8155

what is identity columns in TD?

Wipro,

2 5680

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 10417

what is identity column in TD?

Wipro,

2 7944

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 3693

Hi, Lookup() is what kind of join ?

Satyam,

6 12209

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 12625

Un-Answered Questions { Data Warehouse }

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.

2772

What are the different types of fact tables used in data warehousing?

993

can we insert all types of charts in a list report? what r the realtime prompts?

2210

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2026

For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

1007

What are the different types of parallelism in ab initio?

1221

What is Cognos script editor?

4229

What is a full backup?

960

SCD2 will work on only dimension tables as well as fact Table?

1401

What are the new features of informatica 9.x at the developer level?

1041

how to debug and test the sas program? : Sas-administrator

1036

i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2370

Can intelligence server integrate with my existing data structure?

1060

What is operational data store (ods)?

1016

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1132

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