DECODE
|
IIF
|
Decode can be used in Select statement
|
IIF cannot be used in a Select statement.
|
EXAMPLE:
DECODE(deptname,"SALES",1,0)
----If DEPTNAME is SALES then return 1 else return zero |
EXAMPLE:
IIF( GRADE > 1, IIF( GRADE < 2, SAL1, IIF( GRADE
< 3, SAL2, IIF( GRADE < 4, SAL3, BONUS))), 0 )
----If the GRADE less than ONE then return zero else return SAL1 OR SAL2 OR SAL3 OR BONUS |
Decode gives better readability to
users
|
IIF does not give good readability
|
Wednesday, January 30, 2013
Difference between Decode and IIF in Informatica?
Subscribe to:
Post Comments (Atom)
Tags
Architecture of UNIX
(1)
Basic Unix Commands
(1)
Data warehousing Quiestions1
(1)
Debugger
(1)
Downloads
(1)
ETL Process
(1)
Fundamentals of UNIX
(1)
Get top 5 records to target without using rank
(1)
Home
(1)
How do you perform incremental logic or Delta or CDC
(1)
Incremental Loading for Dimension Table
(1)
Informatica Complete Reference
(1)
Informatica Functions
(1)
Informatica Powercenter Architecture
(1)
informatica project
(1)
Informatica Quiestions
(1)
Informatica Quiestions3
(1)
Informatica Real time Scenarios
(2)
Informatica scenarios
(3)
Integration Testing
(1)
Introduction of Unix
(1)
Oracle Queries
(1)
Power center Client
(1)
Separate rows on group basis
(1)
TESTING-User Acceptance Test
(1)
Unit Testing
(1)
Unix
(2)
What is informatica
(1)
No comments:
Post a Comment
Thank you :
- kareem