SAP HANA Table Calculated field

[former_member290321]

I have table A which has First Name and Last Name as fields with ClientId as Primary Key,

	 CREATE COLUMN TABLE NAME("FIRSTNAME" VARCHAR (50) null,
	 "LASTNAME" VARCHAR (50) null,
	 "SRNO" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 100 INCREMENT BY 1));

	 

Need to add a calculated field 'FullName' (FirstName + Last Name) at table level so don't have to created calculated column in calculation view. The table has around 40 million records.

CREATE COLUMN TABLE NAME ("FIRSTNAME" VARCHAR (50) null,
	 "LASTNAME" VARCHAR (50) null,
"FULLNAME" VARCHAR (100) null (Need this field as a calculated field i.e FIRSTNAME +LASTNAME) ,
	 "SRNO" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 100 INCREMENT BY 1));

	 

[former_member290321]

I am loading table with SLT and I can add a concat field at the time of loading through SLT but don't want to change SLT at this point of time.

Yes I can do the same in Information view i.e In Calculation View as a calculated column but then it will use analytical engine as well as olap engine and will create a temp table which will impact performance.

If I can add at the table level without changing anything in SLT which I can easily do in other database it will be awesome.

I am looking for Default something like that