This content has been marked as final. Show 12 replies
Does your interface/package/scenario fail or succeed?
If failing: in which step is it failing and which error message is shown?
If succeeding: check in which step of the flow that your object is not inserting the records like you want. You can perform all the SQL's manually one by one on the back-end systems to verify where the problem is occurring.
my interface is showing success status in my operator without inserting any data in the target.
firstly i checked C$ table there in operator it shows no of rows 10 but when i checked that table no rows are there.
firstly i checked C$ table there in operator it shows no of rows 10 but when i checked that table no rows are there.Are you talking about No. of Insert or No. of Rows ? Those 2 are different .
If it is No. of Insert , then those record should be there in your c$ table.
What you can do is that copy the select part of the query which loads into c$ table , run the same in a sql cient like toad , sql*plus etc and see if it is returning data or not.
It is No of Rows only there are 10 recs in my source table and i checked the sql query which is used in loading C$ table it fine and returning all the 10 rows of source.
Check the step "Report statistics" - it will show, how many rows are executed in procedure.
If that is the case then you can run the entire generated code (C$ load step) and see how many are getting inserted actually .
while loading into c$ table select query is retriving the data from my source database and insert is happening on target database. how can i test this step on sqlplus.
the "Report statistics" steps is not there i have checked the operator steps.
Can you paste the exact query generated ?
Edited by: Sutirtha Roy on Apr 4, 2012 2:49 PM
from REF_DATA_DB.BANKING_INSTITUTION BANKING_INSTITUTION
insert /*+ append */ into XXSVB.C$_0XXSVB_BANKS_STAGING
Are these 2 schema resides on the same server or different server ?
they are 2 different servers.
As you said you see the data in C$ but not in I$ or Target . am i right ?
First check if the data you are trying to load is not already present in the target . As you have mentioned you are using Oracle Incremental Update and it check with the target for insert/update records , if records already present they wont be loaded into I$ or Target .
If that is not the case make sure your commit is true.
Hope this helps.