Skip to Content

how to execute multiple insert statement from a table

Hi Experts, How to execute multiple insert statements from table in sap bods I have source table like below. I need to execute Query column insert statement.

db_name table_name load_date Query

EDW_TARGET_DEV PRODUCT_DIM 2017/30/06 insert into target table select * from A

EDW_TARGET_DEV CUSTOMER_DIM 2017/30/06 insert into target table select * from B

EDW_TARGET_DEV EMPLOYEE_DIM 2017/30/06 insert into target table select * from C

EDW_TARGET_DEV TIME_DIM 2017/30/06 insert into target table select * from D

EDW_TARGET_DEV PURCHAGE 2017/30/06 insert into target table select * from E

EDW_TARGET_DEV FINACIAL_DIM 2017/30/06 insert into target table select * from F

EDW_TARGET_DEV PROJECT 2017/30/06 insert into target table select * from G

Thanks Murali

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers