on 07-15-2015 4:08 AM
All,
I have a situation where I want to join two tables say Customer and Genders.
a) Customer Left Join with Genders ( Get all Customers if no Gender exist in Genders table)
b) Customer INNER JOIN with Genders ( Get Customers whose Gender matching in Genders table)
What is the best way to model this scenario.
I can do this using CESCRIPT but I hoping if there is any to do the same using Graphical calc view.
Any expert views?
Thanks,
Hi Naresh,
It depends on your final requirement you can go for left or inner joins, But purely depend on your requirement
1)If your requirement wants customer details then i suggest go head with left outer join
2) since you are saying Gender table with customer table and if you have any join significance between 2 tables go head with Inner join.
If query is a complex one I better suggest you to go for scripting Calculation View. You need to consider the future scope of model how complex is your query is...
CE functions are best to use in SAP HANA for Better performance.
Thanks
vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you please show us the sample tables and data in the same?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.