If you are in Thunder Bay, Ontario , Canada on November 10 11 & 12 then don’t miss movie by Imaginarium Studio Star cast Charlotte, Nora, Brody, August and Anand. Movie Trailer available at – vimeo.com
It is advisable in ETL mappings to perform the join at DB level or with PDO . Still when it comes to source which are from different systems,Informatica joiner transformation is inevitable.
Small explanation of Informatica union transformation. one need to have basic understanding of Informatica union transformation to go through this post. I have tried to place a bird eye view of union transformation with why it is needed and some essentials to of this to get an ok picture of union transformation. Just to start with, below are few inputs which will help all in terms of tricky discussions.
The grain of the table is generally designed based on the model requirement. It could be a DAY or an HOUR. Date Dimension can easily embrace multiple hierarchies in its data such as year -> Month -> Day or Fiscal Year -> Fiscal Quarter -> Month -> Week -> Day etc. Let us see how to load Date dimension using Informatica Powercenter.