????Informatica????mapping????

Common Data Warehousing Requirements

1.01 Aggregation using Sorted Input

1.02 Tracking Dimension History

1.03 Constraint-Based Loading

1.04 Loading Incremental Updates

2.02 Tracking History and Current

2.19 Inserts or Updates

Transformation Techniques

1.05 Error Handling Strategy

1.06 Flat File Creation with Headers and Footers

1.07 Removing Duplicate Source Records

1.08 Transforming One Record into Multiple Records

2.05 Dynamic Caching

2.07 Sequence Generator Alternative

2.08 Streamline a Mapping with a Mapplet

2.09 Reusable Transformations (Customers)

2.12 Using a Sorter

2.14 Pipeline Partitioning Mapping Template

2.18 Using Update Strategy to Delete Rows

2.20 Loading Heterogenous Targets

2.21 Load Using External Procedure

Advanced Mapping Concepts

2.04 Aggregation Using Expression Transformation

2.06 Building a Parameter File

2.10 Best Build Logic

2.11 Comparing Values Between Records

3.01 Transaction control transformation

3.02 Data Cleansing using FirstLogic

Source-Specific Requirements

1.09 Processing VSAM Source Files

1.10 Processing Data from an XML Source

1.11 Joining a Flat File with a Relational Table

Industry-Specific Requirements

2.17 Loading SWIFT 942 Messages.htm

2.17 Loading SWIFT 950 Messages.htm

:)

:-o

:lol:

:mrgreen:

:evil:

:P

:mrgreen:

:twisted:

:P

:twisted:

:?

:cry:

:P

:x