What is the difference between Query transform and SQl transform in BODI?
Latest Answer: 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, ...
What is the difference between lookup(0 and lookup_ext() functions in BODI?
Latest Answer: lookup() - It will compare only single coloumn and return only single portWhere as lookup_ext() - will compare multiple columns and return multiple rows ...
How we will implement Full outer join in BODI?Explain with some examples?
Latest Answer: You can acheive this by two methods1. Use SQl transformation and write your own query2. First apply right outer join and then left outer join and merge it.Ex:- 1. select e.*, d.dname, d.deptno dno, d.loc from scott.emp e FULL OUTER JOINscott.dept d on ...
What is the difference between parallel processing projects and grid processing projects
Latest Answer: First of all Click on the Datastore Tab and then you can get the metadata when you click there you can have sources and targets are available.If you have data in Flat File or XML Format you have another Tab known as 'Format' Tab will be there ...
Latest Answer: Data Integrator hierarchy is as follows project ...
