Creation of View from Mutiple Tables (Union of result sets)

[Former Member]

Hi,

I have started working on Information Steward very recently and Im working on creating some profiling rules in Data Insight.

I’m working on bringing data in two tables together to apply some common rules, I have tried view option but I’m not sure how to create the views as below without joins.

View should have common columns from Table1 and Table2  so I can perform below rules.

1. Check uniqueness of primary key column across both the tables. Like Id – Unique in view below
2. Combination of two different columns should be unique in both the tables. Like First name + Last Name Unique in view

I would like to create a view which is can be done using Aggregator in Information PC and Merger in BODS.

Permenent Employee
Id	First Name	Last Name	Age	salary
6	Sachin	Tendulkar	41	2000
7	Ajay	Jadeja	43	2000
9	Rahul	Dravid	40	2000
Contracting Employee
Id	First Name	Last Name	Age	salary
1	Sourav	Ganguly	41	2000
2	Ajith	Agarkar	38	2000
3	Anil	Kumble	43	2000
View
Id	First Name	Last Name	Age	salary
1	Sourav	Ganguly	41	2000
2	Ajith	Agarkar	38	2000
3	Anil	Kumble	43	2000
6	Sachin	Tendulkar	41	2000
7	Ajay	Jadeja	43	2000
9	Rahul	Dravid	40	2000

Please let me know you thoughts on how this can be achieved in SAP IS

[former_member187605]

This is not possible in IS. You'll have to create a view at db level. Or merge all data into one table, using DS as you say.