Search results for query: *

Hi, The best way would be the Help files, in the Powermart or PowerCentre package. The Help files provided, are quite extensive and provide most of the solutions. If you have access, on the Informatica site itself, there is good amount of information available. Regards, Buzzone

Hello Marc, I faced a similar problem in one of my mappings. I tried to use the mapping variable in an Unconnected Storedproc as a parameter passed to the Storedproc, but even this didn't work. Passing session variable in some script, I suppose is possible in PowerCentre. This is another...

Hi, I dont see any straight forward way of doing this thru Informatica, but may be a command prompt script triggered at the end of the session can do the same OR you can call a COM object to delete the same, during the session. Well, if there is any other way, it will surely help all I...

Hi all, This is regarding Rollback thru Informatica, Suppose we have Normal loading, the commit interval is say 5, and the error occurs at record 8 . Informatica Server rolls back the data till around record number 6. If I need to reject all the incoming data even if I encounter one error then...

well again I found the problem...One of the fields in the normalizer did not have a connected input port, so there was some Id mismatch..

Hi all, I have a normalizer transformation in which there are totally , 38+9+1+1+1 = 49 inputs and 4 single outputs. I am connecting two outputs to One filter transformation and other two outputs to another filter transformation. The mapping that I have created gets validated successfuly...

I think I got it..Maybe the Normalizer tranformation should do the job. Is that right ?

Hi all, I have a field say Field1, having data 'ABC1ABC2XYZ RST3' in the input Text file. I need to put this data as, Field2 ABC1 ABC2 XYZ RST3 in the target table. i.e I need to break the data into parts of constant length 4, and put that as rows. How can we do this in Informatica?