syntax: "companyName"+'-'+"Legal"
Steps:
1. Right click on the SRC folder -->New --> Folder--> Provide folder name --> Ok.
2.Right Click on newly created folder by the above step -->New --> Calculation view.
3. Provide name for the calculation view -->
Namespace - Description.
Data category - Dimension.
Type - Standard
Finally Click on Create
4. Create 2 projections
insert tables in to the projections.
5. Add join node.
feed the join node with 2 projections( by drag and dropping the projections to the join).
6. Double click on the join now.
create the connection between 2 foreign
7. in the properties section.
swap the table to right and left, if needed.
provide the cardinality info
join type: Left outer, right outer & Full outer.
8.in projection (flow chat)
again select the columns in the Mapping tab.
9.Next to Mapping tab --> calculated columns tab --> click on + symbol -->
Provide : name,
in the expression edition --> add expression
"companyName"+'-'+"Legal"
10. double click on Semantics (in the flow chart).
select the foreign key, between the tables.
11. Save all.
12. Right click on the folder below SRC -->Build.
