Answer Detail: RE: Query transform and SQl transform

GeekInterview.com > Interview Questions > Data Warehousing > Data Integration

Print |

Question: Query transform and SQl transform

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

February 02, 2008 06:10:37	#1
gssharma_msc	Member Since: January 2007 Total Comments: 4
RE: 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...