cancel
Showing results for 
Search instead for 
Did you mean: 

How to upload a table column in HANA if DQR works successfully

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

kaus19d
Active Contributor
0 Kudos

Hi ,

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