Archives of the TeradataForum

Message Posted: Thu, 07 Apr 2016 @ 08:50:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I can imagine few solutions, all are artificial, because such application should be rather run on transactional database, not DWH.

1. (TD15.10) - use partition level locking and partition the table e.g. by userid.

2. Create as many such tables as maximum number of multiple users. Other users should access the tables through locking for access view which contains "union all" operators.

3. Multiple processes insert rows into work tables ( e.g. que tables). Separate process started as often as required from cron insert-select work tables into the final.

	<Prev	Next>		<<First	<Prev	Next>	Last>>