Source Qualifier – Full Outer Join

Full Outer Join using Source Qualifier – ‘SQL Query’ Integration service support only Left & Right outer joins. We cannot perform Full outer join using ‘User Defined Join’ properties in SQ, you will get a database error. This can be done by using overriding default ‘SQL query‘ in SQ. Full Outer Join Query SELECT EMP_JOB1.JOB_ID,… Continue reading Source Qualifier – Full Outer Join