Informatica - Could any one please tell me how informatica behaves in the following situation?(Let me explain you

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 207 of 305

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%)

Total Answers and Comments: 1

Last Update: August 27, 2007 Asked by: N SRIRAM K

ODP.NET - Working with Bind Variables together with OracleParameter

ODP NET Working with Bind Variables together with OracleParameter With the help of OracleParameter you can include bind variables within any SQL statement These bind variables are nothing but run time query parameters The values in the SQL statement are bound at run time when we use bind variables m

EDI Mapping and Translation

EDI Mapping and Translation Mapping is a movement of information basically of putting the format of one data document onto another For instance it takes the format of an otherwise incompatible data format and makes it into an EDI compatible data document or conversely takes an EDI document and makes

Microsoft AJAX Library - Functions as Variables

Functions as Variables In JavaScript functions are first class objects This means that a function is regarded as a data type whose values can be saved in local variables passed as parameters and so on For example when defining a function you can assign it to a variable and then call the function thr

ERP Systems as Quality Control Support

ERP Systems as Quality Control Support For the past few years ERP systems have became one of the most powerful tools for quality control management But ERP is just an informatics system that provides support to the integrated business management mosgoogle center Goals of the Quality Control Module i

What is Data Mapping

Data mapping is a very important aspect in data integration. In fact, it is the first step in the many complex tasks associated with data integration which include data transformation or data mediation between a data source and its destination; identification of relationships in data which is vital

Evolution of database systems

The Evolution of Database systems File Management System Hierarchical database System  Network Database System  Relational Database System File Management System: The file management system also called as FMS in short is one in which all data is stored on a singl

How to call C header that is not provided generally by system in C++?

Headers can be called by using extern C Syntax of extern C is: extern "C" <function declaration> for example to call C functions from C++ we can write extern "C" { <function declaration> <function declaration> ...

Assign values during declaration

How to assign values during declaration of variables Declaring variables tells the compiler the data type the variable is assigned and no storage area is allocated during this stage. It is possible to assign values during declaration itself. For example, consider the following program: main() {

Operator, Operand and Expression in C

Operator, Operand, and Expression in are symbols which take one or more operands or expressions and perform arithmetic or logical computations. Types of operators available in C are as follows: Arithmetic Assignment Logical/relational Bitwise These have operators under each

Swap two variables

How to swap two variables without using third variable? A variable is a named location in memory that is used to store data which can be modified in a program. Let us learn how to swap two variables without using third variable. This can be done in number of ways By using arithmetic operators

Informatica FAQ Related

—