Can we use LEFT OUTER JOIN in SQL query override with SAMPLE key word?

Can we use LEFT OUTER JOIN (ANSI SQL standard) in SQ query override with SAMPLE key word?
(help me my dba used same in a mapping which have 5 rel SRCS from a single db and contain expression -- directed to TGT)

Interview Candidate
Jul 27th, 2007
3
5272

Informatica

Answer

Showing Answers 1 - 3 of 3 Answers

N SRIRAM K
Profile Answers by N SRIRAM K Questions by N SRIRAM K

Aug 7th, 2007

Yes, You can use LEFT OUTER JOIN or other JOINS in SQ trans

Sriram Kumar N

Aug 10th, 2007

You can use LEFT OUTER JOIN or RIGHT OUTER JOINS in source qualifier trans as SQL override. But make sure that you are not combining two or more outer joins using the same table as the inner table of more than one outer join.

More information reach me @ sriram . kumar @ oneindia . in

N SRIRAM K
Profile Answers by N SRIRAM K Questions by N SRIRAM K

Sep 7th, 2007

Adding to Mr. Sriram Kumar,
As per the investigation I did with SAMPLE keyword in SQ trans......and fortunately its working.............Thx