Does it work if you write query with LEFT OUTER JOIN (same keyword used in) in SQ trans? (It is sql query override in SQ trans, used 5 tables to join with SQ trans)
Does it work if you write query with LEFT OUTER JOIN (same keyword used in) in SQ trans? (It is sql query override in SQ trans, used 5 tables to join with SQ trans)
Thx
SRIRAM N
Hope Everything Good
I will take but make sure database is oracle.
Data base is not Oracle ...We are using Teradata
Thx
SRIRAM N
Hope Everything Good
i am not sure of TERADATA.
please check for the compartible syntax for that database.
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
No doubt, I tried this it will work in informatica. Thx
Last edited by N SRIRAM K; 09-07-2007 at 10:13 AM.
Thx
SRIRAM N
Hope Everything Good