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