Datawarehouse Architect

When you develop a mapping, use the following procedure as a guideline:  Developing Mapping in Informatica Verify that all source, target, and reusable objects are created. Create source and target definitions. If you want to use mapplets, you must create them also. You can create reusable transformations in the Transformation Developer, or you can create them while you develop a mapping. Create the mapping. You can create a mapping by dragging a source, target, mapplet, or reusable transformation into the Mapping Designer workspace, or you can choose Mapping-Create from the menu. Add sources and targets. Add sources and targets to the mapping. Add transformations and transformation logic. Add transformations to the mapping and build transformation logic into the transformation properties. Connect the mapping. Connect the mapping objects to create a flow of data from sources to targets, thro...

Mappings in Informatica Overview: Mappings represent the data flow between sources and targets. When the Informatica Server runs a session, it uses the instructions configured in the mapping to read, transform, and write data. Every mapping must contain the following components:  Source definition. Describes the characteristics of a source table or file.  Transformation. Modifies data before writing it to targets. Use different transformation objects to perform different functions.  Target definition. Defines the target table or flat file.  Connectors. Connect sources, targets, and transformations so the Informatica Server can move the data as it transforms it. A mapping can also contain one or more mapplets. A mapplet is a set of transformations that you build in the Mapplet Designer and can use in multiple mappings. When you add an object to a mapping, you configure the properties according to the way you...

Slowly Changing dimensional in Informatica with example ( SCD -1, SCD -2 , SCD -3) Dimensions that change over time are called Slowly Changing Dimensions. For instance, a product price changes over time; People change their names for some reason; Country and State names may change over time. These are a few examples of Slowly Changing Dimensions since some changes are happening to them over a period of time. slowly changing dimension in informatica Slowly Changing Dimensions are often categorized into three types namely Type1 , Type2 and Type3 . The following section deals with how to capture and handling these changes over time. The "Product" table mentioned below contains a product named, Product1 with Product ID being the primary key. In the year 2004, the price of Product1 was $150 and over the time, Product1's price changes from $150 to $350. With this information, let us explain the three types of Slowly Changing   Dimensions. Prod...