This article explains the why we get an ‘ORA-00960: ambiguous column naming in select list’ error when trying to execute the query generated by the cube view.
Steps to reproduce:
‘ORA-00960: ambiguous column naming in select list’
Test Data Manager - GT Datamaker
In GTSubset, users are allowed to create extracts without specifying the schema. This means that the query may not be fully qualified. This query may not work well within Datamaker by the "Create cube view" generator.
Please make sure that your GTSubset extract is fully qualified before you try to use it in the cube view generator of Datamaker. That is you need to qualify every table or column name with schemaname.tablename or schemaname.tablename.columnname.
For more information regarding Defining Cube dimensions and creating the Cube View, see https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/create-a-data-model-and-audit-pii-data/data-discovery-and-profiling-using-datamaker/define-cube-dimensions-and-create-the-view.html