Step1 :-
Create Source table for chunk loading.
CREATE TABLE countries_check
( "COUNTRY_ID" CHAR(2 BYTE) CONSTRAINT "COUNTRY_ID_NN" NOT NULL ENABLE,
"COUNTRY_NAME" VARCHAR2(40 BYTE),
"REGION_ID" NUMBER
);
Step2 :-
Load the data
begin
for i in 1..1500 loop
insert/*+ append */ into countries_check values ('b','USA',seq_chuck.nextval);
end loop;
end;
Step 3:-
created the Mapping that load the data form source table countires_check to Countries_tgt_view.
Step 4:-
Configure the chunk parameters :-
Right click Map-> Configure
chunking Stategy :- Serial
Chunk Size :- 1 (number of rows to be loaded in each iteration
Chunk table :- Countries_check (Source table )
step 5:-
Max Check Iterator count :- 5000000
Chunk stop if no data. -tick yes
Mapping will loop maximun to 5000000 or the when no data is found
whatever condition meet first.
Step 5:-
Deploy and run the map
Cheers
Nawneet
