Query transform and SQl transform

What is the difference between Query transform and SQl transform in BODI?

Questions by etl_bhargavi

Showing Answers 1 - 6 of 6 Answers

gssharma_msc

  • Feb 27th, 2008
 

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...

amuh1026

  • May 23rd, 2011
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions