Test Data Manager

  • Private Community

  • 1.  data population from multiple table to single table

    Posted Dec 05, 2017 11:31 AM

    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.



  • 2.  Re: data population from multiple table to single table
    Best Answer

    Broadcom Employee
    Posted Dec 06, 2017 09:20 AM

    You could do both for data creation by setting up the required function in datamaker. Try using function like the below to fetch data from other table.

     

    @seqlov(percnull,@sqllist(S,sql)@,column)@