[Step By Step]在SAP Business Objects Data Services中使用Table Comparison Transform表比较功能并导入到SAP HANA中(Table Comparison Transform)

时间:2021-12-17 16:52:15

1. 登陆进入SAP Business Objects Data Services Designer中

 

2. 创建Data store SAP HANA(SAP HANA的连接)

SAP HANA http://www.cnblogs.com/omygod/archive/2013/05/23/3094306.html

 

3. 源数据准备

使用前面导入系统中的DIMCustomer作为源数据

 

4. 新建project, batch job及data flow

[Step By Step]在SAP Business Objects Data Services中使用Table Comparison Transform表比较功能并导入到SAP HANA中(Table Comparison Transform)

 

5. 在左下角选择源数据,并拖动到data flow中

[Step By Step]在SAP Business Objects Data Services中使用Table Comparison Transform表比较功能并导入到SAP HANA中(Table Comparison Transform)

 

6 从左下角拖动table  comparision到data flow中,并连接

[Step By Step]在SAP Business Objects Data Services中使用Table Comparison Transform表比较功能并导入到SAP HANA中(Table Comparison Transform)

 

双击Table_Comparision

[Step By Step]在SAP Business Objects Data Services中使用Table Comparison Transform表比较功能并导入到SAP HANA中(Table Comparison Transform)

[Step By Step]在SAP Business Objects Data Services中使用Table Comparison Transform表比较功能并导入到SAP HANA中(Table Comparison Transform)

 

7。创建table template,并连接

[Step By Step]在SAP Business Objects Data Services中使用Table Comparison Transform表比较功能并导入到SAP HANA中(Table Comparison Transform)

双击table

[Step By Step]在SAP Business Objects Data Services中使用Table Comparison Transform表比较功能并导入到SAP HANA中(Table Comparison Transform)

 

8 运行job

该例中job运行一次之后,我们在源数据中再添加一条新的记录

[Step By Step]在SAP Business Objects Data Services中使用Table Comparison Transform表比较功能并导入到SAP HANA中(Table Comparison Transform)

[Step By Step]在SAP Business Objects Data Services中使用Table Comparison Transform表比较功能并导入到SAP HANA中(Table Comparison Transform)

[Step By Step]在SAP Business Objects Data Services中使用Table Comparison Transform表比较功能并导入到SAP HANA中(Table Comparison Transform)

 

9 在data flow中查看数据

[Step By Step]在SAP Business Objects Data Services中使用Table Comparison Transform表比较功能并导入到SAP HANA中(Table Comparison Transform)