Chunk Loading in OWB 11G R2

Let's explore the Loading data using new feature in owb 11gr2.



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