ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Business Objects
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
Difference between Decode and Case?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Difference between Decode and Case?
Answer
# 1
Decode: using for reporting purpose. and it is implemented
by if stmt.
Ex: select decode(job,'CLERK','executive',job) from emp;

Case : implemented by if & elsif condition. it is using
pl/sql equality conditionality.
Ex : select  case job='CLERK' then 'executive' else 'no' end
a from emp;

it is also used for multipul colms & multi conditions.

in above stmt a is reffered alias name.
 
Is This Answer Correct ?    6 Yes 5 No
Vasu
 
  Re: Difference between Decode and Case?
Answer
# 2
Decode and Case functionwill work in the same way.the only 
difference is we can write conditions in side the case 
function.
for Ex;
case(if c>d,d...)
decode(job,'clerk'...)
 
Is This Answer Correct ?    4 Yes 1 No
Satishe
 
 
 
  Re: Difference between Decode and Case?
Answer
# 3
Decode
1.It’s a function
2.can compare only discrete vaules
3.Pl/Sql standards
4.cannot process null 

Case
1.It's an Expression
2.can hande range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null
 
Is This Answer Correct ?    4 Yes 3 No
Pari
 
  Re: Difference between Decode and Case?
Answer
# 4
Decode
The default operator for comparison is '=',
for e.g select deptno,decode
(deptno,10,'dept10',20,dept20,default)

so if the deptno=10 then the value is replaced by dept10 
and so on,

whereas in Case:

we can use any operator other than '=',
for e.g 
select deptno,
case when deptno=10 and sal>1000 then 'dept10'
else
'dept20'

Hope the difference is made clear.

Regards,
Judith
 
Is This Answer Correct ?    7 Yes 0 No
Judith
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI TCS5
how can we overcome by loops?and also is it possible ,one user can different universe  4
Difference between Decode and Case? TCS1
What are the Errors in BO Pls Explain with Examples iFlex2
Instead of cms which server you have to use? CTS2
what is crosstab reporting,slice and dise and drill mode??  1
WHAT KIND OF TOOL BO IS?  5
what is the use of merge option in webi reports? explain with example? TCS2
i want to hide a chart in reporting level? i want to hide a prompt in designer level? TCS1
Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?  1
What is the difference between Thin client & thick client?  2
in universe perameter u dont give the option multiple contexts ,what is the impact in report level Accenture2
When a report in Web intelligence is created with ten objects and save the same as PDF the report divides the report into two pages. One page with data for five objects and the other with next five objects? Is there a way to combine these ten columns in a single page view?  2
what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe? Fujitsu2
how to test reports in businessobjects? TCS5
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.  1
How can we acheive Correlated sub-query in Designer? Wells-Fargo1
difference between web intelligence,crystal reports and desktop intelligents  3
use scheduler to refresh report.....explain please.....  1
how many times can use the union operator in a report?  2
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com