0

"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.

Regards

Rudra

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.

    Reply Like
  • 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

    Reply Like
Like Follow
  • 4 wk agoLast active
  • 2Replies
  • 56Views
  • 3 Following

Welcome!

Welcome to Incorta's user community! Whether you are already an Incorta customer, or interested in becoming one, this is your place to come together and discuss the software, register for webinars, learn about events, learn about new product releases and get support from the community.