I was wondering how we can determine the number of non-business days between two dates. I am trying to exclude only weekends. Need to achieve it through Informatica expression transformation.
Considering your non working days are saturday and sunday you could do the following.
You could convert the date to a Day format and check if the day is 1-Sunday or 7-Saturday and exculde them in the expression or filter transformations.
eg: if you "Date" - "11/14/2012" - Wednessday
An expression in the expression transformation
To_CHAR(Date,"D") will give you day as 4. You could use this in an if expression or in filter transformations after expression transformations.
I believe that you will use this information for scheduling the session / workflow run. Although the following example is not tailor made for you, it should give you enough idea on how to achieve this.
In addition to this, you will also find over 100 mapping samples on Informatica Marketplace website.