Enable and Disable Scheduler from Backend

Enable and Disable Scheduler from Backend

BEGIN

dbms_scheduler.enable('GEO_TRANS_PF_JOB');

END

BEGIN

dbms_scheduler.disable('GEO_TAG_PF_JOB');

END;

"Single-task message" OWB Wait

I Search the net for the wait event "single-task message" got below information on

http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/WE200/Default.aspx

"When running single task, this event indicates that the session waits for the client side of the executable."

I found that, if the mapping is in "invalid state" is called in the process flow then the process flow will hang forever and we get "single-task message" wait in the v$session table.

"invalid state" means = Mapping is working fine , then we change it but not able to deploy.



Hope this will someone .


Cheers
Nawneet

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

DML Error Tables

Today we are going to explore the DML Error Logging using OWB11R2.

1.Already created module and location with SCOTT user.

2. Will try to insert the records into DEPT table having primary key on DEPTNO.

3.Mapping will look like this :- Dept1 -> Dept

4.Check the data in DEPT table from Sqldeveloper. 8 rows

5.Check the data in DEPT1 table from Sqldeveloper . 12 row

all are 12 rows are already present into target table (DEPT)

6.Configure the mapping to Handle DML Error Table as DEPT_ERR.

7.After mapping execution the all the 12 records are there in DEPT_ERR table and

Mapping run successfully.