Creating a load transaction involves defining the mappings between the source and target data objects. Mapping defines the relationship and data flow between source and target objects.
Before building an actual data map for the loading process, define a data model for the target even if it is not an actual database. This helps understand the entities it belong to and makes it 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 Execute, Transform, Load (ETL), you have to first analyze the data content, complete business rules for ETL process, integrate data sources to a single source, before you can build an actual data map.
BIRT Analytics Loader supports creating multiple load transactions per project.
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