AnsweredAssumed Answered

data population from multiple table to single table

Question asked by NEW_ACCOUNT on Dec 5, 2017
Latest reply on Dec 6, 2017 by Anil Kumar Appukuttan

I have data in different tables and different database. and a composite table in other database.
1. Is there any scope in data maker to populate data from different table in different database to composite table ?

2. Is there any scope in data maker to populate data from different table to a composite table in same database.

IfF YES , can you please share the flow. this requiremnet i am looking in sql server database.

example. 1.
DB1.T1.CO1 DB2.T1.CO1 DB2.T1.CO2 DB3.T1.CO1 DB3.T1.CO2
1 A B DB1.T1.CO1 DB2.T1.CO1

example -2
DB1.T1.CO1 DB1.T2.CO1 DB1.T2.CO2 DB1.T1.CO1 DB1.T1.CO2
1 A B DB1.T1.CO1 DB12.T1.CO1

 

Thank you.

Outcomes