This content has been marked as final.
Show 3 replies
-
1. Re: How can create a temporary table for all the sessions
shawkins Nov 11, 2014 8:06 AM (in response to jchidiac)> any help ?
Both global and local temporary tables have their data as session scoped. Either you need to ensure it is reused within the session or introduce a new source table which would be accessible in all sessions.
-
2. Re: How can create a temporary table for all the sessions
jchidiac Nov 11, 2014 8:17 AM (in response to shawkins)if i don't want to create a physically table on the DataBase
how can i introduce a new source table ?
-
3. Re: How can create a temporary table for all the sessions
shawkins Nov 11, 2014 8:55 AM (in response to jchidiac)Unfortunately you'll have to resort to using an external source and add a corresponding metadata entry at design time (or via dynamic vdb import) or bring it into scope temporarily with create foreign temp table. Either way it does require a database or other source system.