Extracting the MDM Extension for Google BigQuery package
Download the MDM Extension for Google BigQuery package from the download site to a directory on your machine.
To get the link to the download site, contact Informatica Global Customer Support.
After you download the MDM Extension for Google BigQuery package, extract the package on your machine.
The extracted package contains the following files and folders:
File or Folder Name
Description
1_BigQuery_Staging
Folder that contains the BigQuery_Staging.zip file. The BigQuery_Staging.zip file contains scripts to create the Google BigQuery staging store.
2_BigQuery_Analytics
Folder that contains the BigQuery_Analytics.zip file. The BigQuery_Staging.zip file contains scripts to create the Google BigQuery analytical schema.
3_DI_Assets_Staging
Folder that contains the following files:
- Customer_Staging.zip. Contains Cloud Data Integration assets to write customer master data to the Google BigQuery staging store.
- Product_Staging.zip. Contains Cloud Data Integration assets to write product master data to the Google BigQuery staging store.
- Supplier_Staging.zip. Contains Cloud Data Integration assets to write supplier master data to the Google BigQuery staging store.
- Location_Staging.zip. Contains Cloud Data Integration assets to write location master data to the Google BigQuery staging store.
4_DI_Assets_Analytics
Folder that contains the DI_Assets_Analytics.zip file. The DI_Assets_Analytics.zip file contains Cloud Data Integration assets to write data from the Google BigQuery staging store to Google BigQuery analytical dimension and fact tables.
5_MDM_Jobs_Assets_Staging
Folder that contains the following files:
- Customer_Jobs_Assets_Staging.zip. Contains jobs to egress customer master data to the Google BigQuery staging store.
- Product_Jobs_Assets_Staging.zip. Contains jobs to egress product master data to the Google BigQuery staging store.
- Supplier_Jobs_Assets_Staging.zip. Contains jobs to egress supplier master data to the Google BigQuery staging store.
- Location_Jobs_Assets_Staging.zip. Contains jobs to egress location master data to the Google BigQuery staging store.
Secure Agent Files
Contains parameter values for the Cloud Data Integration mappings.