Data Warehouse Interview Questions
Questions Answers Views Company eMail

Difference between Force_error & Force_abort?

Wipro,

2 13448

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

1745

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

TCS,

5 13561

How many macros we can create inside a macro

Wipro,

1 5967

what is identity columns in teradata

Wipro,

2 8285

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

Wipro,

2 5932

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

Wipro,

3 6672

what is identity columns in TD?

Wipro,

2 4655

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

CTS, Deloitte,

1 4896

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 9165

what is identity column in TD?

Wipro,

2 6898

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

IBM,

1773

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 2906

Hi, Lookup() is what kind of join ?

Satyam,

6 10242

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 10562


Un-Answered Questions { Data Warehouse }

What are all the components of Report Studio?

651


What are the data types in sas?

596


What do you understand by a term domain?

657


Differentiate between Join, Merge and Lookup stage?

635


What do you understand by user class in cognos?

526






Explain bus schema?

543


Is possible to create skid in dim,fact tables?

2178


Target increases every day even though no new record was inserted

1098


How to update source definition?

619


explain the proc in sas? : Sas-administrator

604


What are sequencers?

606


Where the data cube technology is used?

541


hi friends pls forward impropmtu interview question

1679


Explain 4gt switch?

509


What Proc glm does?

599