on 09-26-2016 11:58 AM
Hello Experts.
I need to update a table column in SAP Hana if the remediation works successfully.
To provide in context with the solution I need to implement, with BODS, I set a value in a Hana Error Table when the data don't pass the validation transform.
This data goes to SAP MDG in a DQR solution and there's a user who remediates this data.
When the data is remediated, it's loaded in a Staging Area in MDG to be part of the Master Data Catalog.
How I can upload the error table automatically and set a new value (remediation OK) when the remediation concludes succesfully?
Thank you in advance.
Does this matter include any print-screen because I can not see any 1 of them in particular in here. Anyways coming back to topic,
If you want to only insert select columns:
considering AAA and YYY are two different schema names and table1 is of same definitions/structure under both schema name, then Try this,
INSERT INTO "YYY"."table1" (A,B) SELECT A,B FROM "AAA"."table1";
Hope the below mentioned links too will help in this regard,
Load/Unload a Column Table into/from Memory - SAP HANA Administration Guide - SAP Library
HANA Merge and Optimize Compression process | SCN
Thanks,
Kaushik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.