Creating a load transaction involves defining the mappings between the source and target data objects. Mapping is the definition of the relationship and data flow between source and target objects.
Before building an actual data map for the loading process, you have to define a data model for target even if it is not an actual database. It will help you understand the entities to which it belongs. Then it will be easier to find the similar entity in the source and map it to the target element. This is called building a logical data map model and you have to do it before you actually start mapping the data.
After you have built a data map model for ETL (Execute, Transform, Load), you have to analyze the data content, complete business rules for ETL process, integrate data sources to a single source, and only then build an actual data map.
BIRT Analytics Loader supports creating multiple load transactions per project, as shown in Figure 3‑26.
Figure 3‑26 Creating multiple load transactions
You have the following choices when you create a load transaction:
New from file
Define a transaction that creates a table mapped to a flat file connection.
New from database
Define a transaction that creates a table mapped to a database.
New from file