IICS | Sequence transformation | Load alternate records #informatica #tamil

Sequence Transformation - Load alternate records
1. Source - EMP table
2. Transformation - Sequence, Filter
3. Target - T_EMP_SEQ

Scripts Used:
drop sequence emp_id_seq ;

create sequence emp_id_seq;

--private temp table available from 18c...
--specific to current session only.
--you need to prefix "ora$ptt_" and your table name
CREATE PRIVATE TEMPORARY TABLE ora$ptt_test_emp_seq
as
(
SELECT
emp.*
FROM
emp) ;

select * from ora$ptt_test_emp_seq t

create table t_emp_seq
as select * from emp where 1=2;

select * from t_emp_seq ;