Query transform and SQl transform

SQL Transform - Here you can wirte your customized SQL queries.

Query Transform - This is one of the best tranformation in BODI, where it gives u different functionalities like Extracting data, sorting, Joins, create new o/p columns,
nested schemas, generate DTD's, XML schemas.
You  can map from source In_schema to Target Out_Schema.
You can apply functions to ur columns etc...

  1 User has rated as useful.

  

Login to rate this answer.

Query transform is something you build using the BODI, and it generates the optimised SQL, where SQL transform allows you to enter the SQL query directly.