Please convert query oracle to teradata

General

Please convert query oracle to teradata

Please convert query oracle to teradata

select address.address_id,address.state,dim_tab.src_system,dim_tab.dim_last_mdfd_dt from address,dim_tab where

dim_tab.src_system(+)='rama' and

address.address_id=dim_tab.ods_addr_id(+) and

address.state=dim_tab.ST(+)

Appreciate  for your quick responce.

Thanks

vamsi

1 REPLY
Enthusiast

Re: Please convert query oracle to teradata

select address.address_id,address.state,dim_tab.src_system,di m_tab.dim_last_mdfd_dt

from address

left outer join dim_tab

on address.address_id=dim_tab.ods_addr_id

and address.state=dim_tab.ST

and dim_tab.src_system='rama'