[Step By Step]在SAP Business Objects Data Services中使用Key Generation Transform主键列生成并导入到SAP HANA中(Key Generation Transform)

时间:2021-11-06 16:55:29

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. 源数据准备

该例程中的数据使用已导入到SAP HANA中的数据DIMCustomer

 

4. 新建project, batch job及data flow

[Step By Step]在SAP Business Objects Data Services中使用Key Generation Transform主键列生成并导入到SAP HANA中(Key Generation Transform)

 

5 拖动源数据到data flow中

[Step By Step]在SAP Business Objects Data Services中使用Key Generation Transform主键列生成并导入到SAP HANA中(Key Generation Transform)

 

6. 创建key generation

[Step By Step]在SAP Business Objects Data Services中使用Key Generation Transform主键列生成并导入到SAP HANA中(Key Generation Transform)

双击Key_Generation

[Step By Step]在SAP Business Objects Data Services中使用Key Generation Transform主键列生成并导入到SAP HANA中(Key Generation Transform)

 

7 创建template table

[Step By Step]在SAP Business Objects Data Services中使用Key Generation Transform主键列生成并导入到SAP HANA中(Key Generation Transform)

双击

[Step By Step]在SAP Business Objects Data Services中使用Key Generation Transform主键列生成并导入到SAP HANA中(Key Generation Transform)

[Step By Step]在SAP Business Objects Data Services中使用Key Generation Transform主键列生成并导入到SAP HANA中(Key Generation Transform)

 

8 执行job两次

[Step By Step]在SAP Business Objects Data Services中使用Key Generation Transform主键列生成并导入到SAP HANA中(Key Generation Transform)

[Step By Step]在SAP Business Objects Data Services中使用Key Generation Transform主键列生成并导入到SAP HANA中(Key Generation Transform)

9 在data  flow中查看数据

[Step By Step]在SAP Business Objects Data Services中使用Key Generation Transform主键列生成并导入到SAP HANA中(Key Generation Transform)

10 在sap hana中查看数据

[Step By Step]在SAP Business Objects Data Services中使用Key Generation Transform主键列生成并导入到SAP HANA中(Key Generation Transform)