Informatica - Can we use LEFT OUTER JOIN (ANSI SQL standard) in SQ query override with SAMPLE key word?(help me my

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 199 of 301

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)

Total Answers and Comments: 3

Last Update: September 07, 2007 Asked by: N SRIRAM

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 07, 2007 10:56:08

N SRIRAM K

Member Since: May 2007 Contribution: 115

RE: Can we use LEFT OUTER JOIN (ANSI SQL standard) in ...

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

Is this answer useful? Yes | No

August 10, 2007 00:53:49

Sriram Kumar N

RE: Can we use LEFT OUTER JOIN (ANSI SQL standard) in ...

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

Is this answer useful? Yes | No

September 07, 2007 10:55:31

N SRIRAM K

Member Since: May 2007 Contribution: 115

RE: Can we use LEFT OUTER JOIN (ANSI SQL standard) in ...

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

Is this answer useful? Yes | No

Go To Top