The sample catalog contains the ETL implementations for ClearCase® base and UCM.
In the sample ETL implementation, the object unique ID is used
as natural key and mapped to EXTERNAL_KEY2 in tables
in the data warehouse.
Because it is more efficient to retrieve data with several small
requests than for each artifacts and relationships with a separate
request, staging is implemented.
- For ClearCase base,
only one staging build FileVersion_Stg is used
to retrieve all information about the file elements and file versions.
- For ClearCase UCM, FileVersion_Stg, Project_Stg,
and Component_Stg are used to load other UCM artifacts.