Epoch Date Converter
Posted by: Partha Sen
An example of PowerCenter mapping to convert Epoch date or Unix date (an integer value) into actual local date time.
Overview
This mapplet can be used in any Informatica mapping that requires converting Epoch date or Unix date (an integer value) into actual local date time. Note :UNIX time or POSIX time, is a system for describing points in time, defined as the number of seconds elapsed since midnight proleptic Coordinated Universal Time (UTC) of January 1, 1970, not counting leap seconds. It is used widely, not only in Unix-like operating systems, but also in many other computing systems and file formats.More details about Epoch date or Unix date can be found online. As per Wikipedia:
- Source : Wikipedia
Features
System Requirements:
- Informatica PowerCenter 9.1 and 9.5
- Assumes user to have basic Informatica knowledge of Repository Manager, Designer, Mapplets, expressions, etc.
- Assumes basic SQL experience of user.
Resources
More details about Epoch date or Unix date can be found online. As per Wikipedia:UNIX time or POSIX time, is a system for describing points in time, defined as the number of seconds elapsed since midnight proleptic Coordinated Universal Time (UTC) of January 1, 1970, not counting leap seconds. It is used widely, not only in Unix-like operating systems, but also in many other computing systems and file formats. Source: http://en.wikipedia.org/wiki/Epoch_timeSupport
Email: sen.partha.sen@gmail.com
