"Union All" of two different database table

Hi Team,

I want to use "union all" function between two different database table(DB-1/T1  & DB-2/ T2) like Oracle(SQL), can you pease let me know how I can achieve this?


Thanks in advance.



2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi  Rudra ,

    There are a couple ways the product will let you achieve this, but the most common way is to define multiple sources for your Incorta table definition.  The approach works best when DB1.T1 and DB2.T2 have the same columns, as this approach requires that the results coming from the different table source defintions agree on column name and type.  Aliases can be used in the defining SQL SELECT statements to subtle adjustments to force agreement.  There are other ways to do this that get slightly more complex (like bringing in DB1.T1 & DB2.T2 as-is as Incorta tables and then defining a Materialize View on top of them to build a unified unioned table).  See screenshot.

  • Can you put more screen shots . I believe salesorderdetail table from Adventureworks and POS have same structure. if not then how to arrive at common structure

Like Follow
  • 1 yr agoLast active
  • 2Replies
  • 159Views
  • 3 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!