Datawarehousing Informatica Questions

I have had one requirment URGENT:

SRC (flat file) --> SRC QFR --> EXP --> STR PROC --> TGT

Inputs for stored procedure transformation are 3,
1) name string 2) add string and 3) S_date
Getting date as string from SRC and converted the string to Date format mm/dd/yyyy in expression. But the problem is stored procedure wants the input as single digit for less than 10 numbers.
For ex: 1/1/2006 (it won't accept 01/01/2006). But our expression transformation gives date as 01/01/2006.

How to send the input for stored proc as 1/1/2006?

(Don't advice me change date format in stored procedure. I wish to get it from informatica if possible)

Thx

We encounter a problem in Informatica when handling number datatypes from Oracle.

In the Oracle database, I have the values as "46516387.47" and "46513795.02". I have defined them as number(30,10) and decimal(30,10) in oracle and informatica definition. When this data is read in the source qualifier, I am getting like "46516387.4699999988" and "46513795.0200000033" as I see in the debugger. When i go to Evaluate expression and check the values i could see "46516387.469999998807907" and "46513795.020000003278255". Since I am using these values for performing multiplication and division in my mapping, I am not getting the desired results because of the mismatch in the values.

And this happens even when I enable high precision.

Hi GEEKS,
Could you please clear me what will be the difference between different connections like ODBC,DNS,DSN and Others?

Thx

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

What is the use of LOAD CONFIGURATION in designer?

What is a SUPER GLUE Server in designer? How do we configure them?

What is a DATA LINEAGE? How to configure it? (Designer)

Hi Sriram,

Using TO_FLOAT conversion function, we can get the exact decimal number.

Thx
Prakash