Loading data into a base object is known as a load job. All Master Data Management operations to obtain Golden record will be performed on this base object record. Here are the different possible ways to load data into base object or to call load job:
1. Batch Viewer :
You can execute MDM load job directly from hub console . In hub console under batch viewer tab you will get list of base object. Select base object and perform load Job.
- user should have hub console access
- batch job metrics will be accessible easily
- Job History will be visible to user
- Job scheduling is not possible
2. SIF API :
Informatica provides SIF API ExecuteBatchLoad to call load job. This API can be called from SOAP UI or by using java EJB call. You can call SIF API from SOAP to load data into MDM.
- User does not require to login hub console
- It does not provide user interface to get job metrics and job history
- API can be called from java class by creating EJB client
Sample Request Parameter:
username - user who is executing this load job
password - password of the user
orsId - databse ID
tableName - stage table name
forceUpdateInd - 1 or 0 ( if the value is 1 MDM loads data regardless of last update date and if 0 , MDM only loads data that has more recent last update date)
Sample ResponseParameter:
message : Contains a message regarding status of the job
retCode : Provide return code
3. Command Line Batch Execution:
MDM batch load can be performed by command line execution. This can be done using The Command Line Batch Execution Resource Kit.
-username -password action -tablename [-forceload]
- Command Line Batch Execution internally calls SIF API
- User does not require hub console access
- User can call this job from any scheduler tool
- Can be used in shell scripts
If you know of any other ways to execute a load job, we'd love to hear from you in the comments section