Can we update Sql in data transform using data transform
Can we update Sql in data transform using data transform
***Updated by moderator: Lochan to add Categories***
Posted: 5 years ago
Posted: 5 years ago
I am not sure I understand the intent of generating SQL through data transforms. Could you elaborate on the use cases which need custom SQL generated through data transforms?
Posted: 5 years ago
In need to update some value of internal database , I know it can be down through activity, just wanted to be sure whether it can be done through data transform.
Posted: 5 years ago
I dont think using data transform sql table can be updated, only set or data manipulation can be done through data transform but it can perform other methods which is easily done through activities .
Accepted Solution
Posted: 5 years ago
Right, you can generate the SQL using data transforms but you need an activity or function to execute it.
is the use case to build the query using properties pxSelectStatement & pyWhereClause and call RDB- methods to process the query? if yes, we could build the query from data transforms.