Incremental loading is nothing but the cdc(change data
used to capture the data like insert,update and deleted
data on a table.
1)for this we need exec the sp against the db is to enable
the cdc.(select is_cdc_enabled where db_name='cdc_test')
2)Enable the cdc against the table in the db.(exec
3)wheather the db/table enabled for the cdc by writing a
select query aginst db/table.If it returns 1 enabled or it
returns 0 not enabled.
(select is_tracked_by_cdc from sys.tables where tab_name='--
Incremental load is adding/loading only changed/latest updated
data from the source.In incremental loading,history data
could remain as it is along with the new data or
overwritten by incremental data and also the other load type is full load where we go for full refresh.
In Incremental loading the differnce between the source and
target are dumped at regular intervals. Here we give the
last extract date so that changes only of this particular
date will be loaded to the target tables.
Can anyone know that what is the Source File limitation in
To be more precise ..
how many flat file we can use as a source in a mapping if..
1) The Structure of flat files are same
2) If the Structure of flat files are different.
Please explain the procedure also if it dosn't bother one much!!
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?