Learning’s Informatica Power Center

1.       Assigning the workflow variables value to the mapping variable in a session (in component tab ->pre-session variable assignment info8.6) is not possible in the reusable session. It will not assign value if it is a reusable session. If you want to assign the value like that go for normal session. i.e session created in workflow directly.

2.       If the parameter is a string no need to give the value in the single quote in the parameter file. Even in the mapping also no need to give single quotes for the parameter.

3.       If you have the reusable session and in workflow if u are calling same session with different name and the corresponding mapping contains parameters, then you need to mention the parameters both session names and the corresponding parameters.

4.       If you have mapplet variables /parameters, in the parameter file give the mapplet name as prefix of the mapping parameter(s).

5.       IS_DATE function will handle both date which is 00000000(yyyymmdd) and date which is invalid (19790332 (yyyymmdd)). This function says these are not dates.

6.       $targetname is workflow variable and $var is mapping variable. If you want to assign the $var value to the $targetname and if the $var variable is getting value from the mapping then assign it in the session àcomponentsà  'post session command succeeded' . (informatica 8.6)

7.       $targetprefix is one more mapping variable and if you want to assign value to this from $targetname (should have value) assing it in session àcomponentsà  pre-session command. (informatica 8.6)

8.       XML Reader error (informatica 7.1.2)

READER_1_1_1> HIER_28056 XML Reader: Error [NoGrammarResolver] occurred while parsing:[Error at (file , line 0, char 0 ): An exception occurred! Type:NetAccessorException, Message:Could not connect to the socket for URL 'http://oasissta.caiso.com/mrtu-oasis/xsd/OASISReport.xsd'.]; line number [0]; column number [0]

READER_1_1_1> Wed Mar 04 11:22:26 2009

READER_1_1_1> HIER_28056 XML Reader: Error [NoUseOfxmlnsAsPrefix] occurred while parsing:[Error at (file /home/infopc/informatica/server/SrcFiles/caliso/price/CALISO_PRICE_RAW_RUC_LMP_GRP_RUC_LMP_4934823.xml, line 2, char 272 ): Fatal error encountered during schema scan.]; line number [2]; column number [272]

READER_1_1_1> Wed Mar 04 11:22:26 2009

READER_1_1_1> HIER_28058 XML Reader Error

 

Solution for the above error

 

Set the attribute 'Validate XML source' to 'Do not validate' in session. Below is the path.

Edit sessionàgo to mappings tabàclick on source file (XML) in Sources folderàproperties (right hand side)àValidate XML Source (4^th attribute)

 

9.       Dynamic lookup- you can only use the equality operator (=) in the dynamic lookup condition.

 

1. 10.   Mapplet: In mapplet, the mapplet output transformation should get data from single transformation (like exp etc) not from two transformations. If we connect  two transformations  to single mapplet output transformation it will validate the mapplet.when we call the mapplet in the mapping and try to validate it will give an error ( it will popup error message about the memory.)