9 Replies Latest reply on Nov 4, 2015 12:13 PM by Christian Berg

    Join

    Sree!!!

      Hi Guys,

       

      Can we specify Outer Joins in the Physical layer? It will be allow to do it manually in the expression box of physical layer

       

      Thanks!!

        • 1. Re: Join
          AkanshAgarwal

          Hi,

           

          The outer joins can be specified in the BMM layer while creating the complex joins.

           

          Thanks,

          Akansh Agarwal

          • 2. Re: Join
            Sree!!!

            HI Akansh,

             

            Yeah that's right but is there any possibility we can give outer joins in the Physical Layer

            Thanks!!

            • 3. Re: Join
              Gianni Ceresa

              Why?

              This is the question: why are you looking for an outer join in the physical layer?

              In the physical layer you define how things are physically related to each other.

               

              The concept of inner, left outer, right outer or full outer join is a business meaning. You need an outer join because the business meaning of your data would be different with an inner join.

              So the tool ask you to define the kind of join in the BMM, and it's a good thing as you can use the same rule (the physical link) once as outer and once as inner just because it's right or wrong, they both mean different things !

              • 4. Re: Join
                Sree!!!

                Hi Gianni,

                 

                I faced one interview they were ask me can we give the  outer joins in the Physical Layer, I told them we can give it in BMM layer but I am not sure in Physical layer, that's why I am checking with you!!

                Thanks!!

                • 5. Re: Join
                  Christian Berg

                  Would have been interesting to check THEIR knowledge since there are actually ways to get an outer join into the physical layer...

                  • 6. Re: Join
                    2709444

                    What are the ways to get outer join in physical layer then?

                    • 7. Re: Join
                      Christian Berg

                      Opaque views and join hints. But I am being obnoxious as I love to do when such questions come and people try to be smug and saying "Oh no your response is incorrect - you can't do outer joins in the physical layer". So slap and bang.

                      • 8. Re: Join
                        2709444

                        As a fresher, I had some doubts and I am asking it. I never said "Oh no your response is incorrect". So you dont have to slap and bang

                        • 9. Re: Join
                          Christian Berg

                          You misunderstood me, not you. The smug interviewer who has canned responses on his paper!