How can we call SQL Function through GTD / FDM from target instance?
scenario: We tried to generate our own sequence for customer ID using Next Val function but its failed out as we are using different sequence. And later we decided the to consume the Next_Customer_ID function in target instance.
But while calling those function we are facing an issue "Aggregate Function are not supported". And we are not able to find any SQL function in GTD to Get our own data base function to generate value to have sync with test environment.
Thanks in Advance!