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)
Printable View
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)
I will take but make sure database is oracle.
Data base is not Oracle ...We are using Teradata
i am not sure of TERADATA.
please check for the compartible syntax for that database.
[QUOTE=N SRIRAM K;14679]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)[/QUOTE]
Sriram,
For Teradata, I am not having any approach for this.
But in informatica, it will not work.
No doubt, I tried this it will work in informatica. Thx