DSXchange

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?

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

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?