| |
GeekInterview.com > Tech FAQs > Informatica
| Print | |
Question: Could any one please tell me how informatica behaves in the following situation?
(Let me explain you with example: I have following expression in a mapping I would display either FAIL or PASS status to a record.
RESULT=IIF((A > (100 - B))OR(C > (100 - D))OR(E<= F AND F>0) , 'FAIL',
IIF(STATUS_I = 'FAIL', 'FAIL', 'PASS'))
Where the following variables are decimals
A (Decimal(9,2)) = 2.0179896789716073791692725900792e-5
B(Decimal(9,2)) = 99
C(Decimal(9,2)) = 50
D(Decimal(9,2))= 99
E(Decimal(9,2))= 0
F(Decimal(9,2))=2681.75
Problem is that system is showing FAIL but expected to be PASS.
How the systems behaves with exponent values?
1) would informatica drops the exponent and takes 2 as 'A'
2) takes exponent (A) as is (0.00%)
|
| August 08, 2007 11:08:55 |
#1 |
| N SRIRAM K |
Member Since: May 2007 Total Comments: 21 |
RE: Could any one please tell me how informatica behav...
|
As I tested:
It should take exponent as near rounded binary value. |
| |
Back To Question | |
