Dataphin:Step 1: Develop a logical dimension table

Background information

After you develop and submit the product logical dimension table, you must also develop and submit the customer logical dimension table. The development process for both tables is identical. This topic uses the product logical dimension table as an example.

Step 1: Create a logical dimension table

1. Navigate to the Dataphin home page and single click Develop on the top menu bar.

2. Follow the steps shown in the figure below to access the Create Logical Dimension Table dialog box.

   

3. In the Create Logical Dimension Table page, configure the following parameters:

   Parameter	Description
   Business Object	Select the Product business object.
   Data Timeliness	The default setting is Offline T+1.
   Chinese Name	Input Product Logical Dimension Table as the name.
   Description	Provide a concise description of the logical dimension table, such as Product Logical Dimension Table.

4. Single click OK to confirm.

Step 2: Configure logical table fields

1. On the Table Structure configuration page, single click Import From Table.

2. In the Add Fields From Table dialog box, select the dataphin_tutorial.product source table and include fields such as product_name, product_category, and product_price.

   Note

   Note: The primary key and associated dimension foreign key fields are automatically included and need not be manually selected.

3. Single click Add to proceed.

4. On the Table Structure page, single click Save And Next.

Step 3: Configure logical table computation logic

1. On the computation logic configuration page, single click Source Configuration to open the Source Configuration dialog box.

2. In the Source Configuration dialog box, click Add Source Object and configure the following parameters:

   Parameter	Description
   Source Table Name	Choose the dataphin_tutorial.product source table.
   Associated Primary Key Field	Select the product_id field.

3. Single click OK to confirm the selections.

4. Drag the selected data source fields into the computation logic column.

5. Single click Save And Next to continue.

Step 4: Configure logical table field constraints

1. On the constraint configuration page, the Rule Strength defaults to Strong Rule. No additional setup is required.

2. Single click Save And Next to proceed.

Step 5: Configure ordinary logical dimension table schedule

1. On the Schedule & Parameter Configuration page, keep the default settings.

2. Single click Save And Submit to finalize the setup.

Step 5: Save and submit the logical table

1. When you click Save And Submit, the system validates the Table Structure, Computation Logic, Schedule Dependency, and Runtime Parameter configurations. If any check fails, review the Check Results to identify and fix the issues.

2. After all checks pass, click OK And Submit to complete the submission.