filmov
tv
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 ;
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 ;