understanding TWT connection in Netezza

vamsi.4a6 · Post by **vamsi.4a6** » Fri Nov 14, 2014 1:08 am

INSERT INTO [[table]]
(col1,
col2,
col3)
SELECT
col1,
col2,
col3
FROM DB1..[[twt]]

I am not able to understand above query in netezza connector.sql query is mentioned in user_definedsql.Properties are mentioned for
TWT connection also.

Could anybody explain above query how it will work?

ray.wurlod · Post by **ray.wurlod** » Fri Nov 14, 2014 3:34 am

Netezza uses temporary work tables (TWT). Is that what is unclear?

vamsi.4a6 · Post by **vamsi.4a6** » Fri Nov 14, 2014 4:37 am

1)My doubt is how [[table]] and [[twt]] will be selected.I have not define anyvalue for [[twt]] and [[table]].

2)What is the advantage of TWT in netezza which is not present in oracle database?