Today i came across this question in OTN forums
http://forums.oracle.com/forums/thread.jspa?threadID=1013609&tstart=0
how to make Outer Joins in Rpd in order to get all the data from a particular fact table.For this
Step1: Import the tables into rpd and make physical joins
Step2:Pull the tables into BMM layer
Step3:Double Click on the LTS under General tab we have Map to these tables section here we need to add the tables to which we want to make the join
Step4:In joins section we have to mention which type of join we need to use (Left Outer,Right Outer,Full Outer,Inner) or we can directly give in BMM layer by using Complex join
http://forums.oracle.com/forums/thread.jspa?threadID=1013609&tstart=0
how to make Outer Joins in Rpd in order to get all the data from a particular fact table.For this
Step1: Import the tables into rpd and make physical joins
Step2:Pull the tables into BMM layer
Step3:Double Click on the LTS under General tab we have Map to these tables section here we need to add the tables to which we want to make the join
Step4:In joins section we have to mention which type of join we need to use (Left Outer,Right Outer,Full Outer,Inner) or we can directly give in BMM layer by using Complex join
Posts
