what is incremental loading ?
Answer Posted / apps
Incremental loading is nothing but the cdc(change data
capture)
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
sys.sp_cdc_enable_table @source_schema=-----,@source_name=-)
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='--
--')
any suggetions revert me via ravipati65@gmail.com
apps
Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
what is diff b/t sorter t/r and agg have the option sorter property...
How are indexes created after completing the load process?
What does command task mean?
Differentiate between a repository server and a powerhouse?
What is persistent lookup cache?
What are active and passive transformations?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is the function of look up transformation?
Mention a few design and development best practices for informatica?
What is blocking transformation?
Explain the different dimensions.
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are mapplets? How is it different from a Reusable Transformation?
What is informatica? Why do we need it?
What is data movement mode in Informatica and difference between them?