> 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.
if i don't want to create a physically table on the DataBase
how can i introduce a new source table ?
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.