✍ Kashif M
Trends

Sunday, 7 July 2013


MAPPING VARIABLES IN INFORMATICA


By on July 07, 2013



1. Go to Mappings Tab, Click Parameters and Variables Tab, Create a NEW port as below.



$$LastRunTime Variable date/time 19 0 Max



Give an Initial Value. For example 1/1/1900.




2. IN EXP Transformation, Create Variable as below:



SetLastRunTime (date/time) = SETVARIABLE ($$LastRunTime, SESSSTARTTIME)




3. Go to SOURCE QUALIFIER Transformation,



Click Properties Tab, In Source Filter area, ENTER the following Expression.



UpdateDateTime (Any Date Column from source) >= '$$LastRunTime' 

AND 
UpdateDateTime < '$$$SessStartTime'



Handle Nulls in DATE



iif(isnull(AgedDate),to_date('1/1/1900','MM/DD/YYYY'),trunc(AgedDate,'DAY'))


Kashif
mkashu: MAPPING VARIABLES IN INFORMATICA
Review : Kashif | Kashif
Update: July 07, 2013 | Rating: 4.5

Comment for "MAPPING VARIABLES IN INFORMATICA"

0 comments

Post a Comment

Blog Archive