Union or Merge in Information Steward

[Former Member]

Hello everyone,

We are looking to profile data in tables spread across 24 different instances. We need to do perform basic profiling across the entire set of data and am looking to do a union of the tables (Merge transform in Data Services). Is there a way to do this in IS and if not, is there a work around? I would think that this would be a commonly encountered scenario in most projects. Thanks in advance!

Regards,

Chaitanya Kasarkod

[former_member186897 · Accepted solution]

Hello Chaitanya,

This is not possible in IS. You need to do union at database level or merge tables using data services.