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

How do you use reject loader.

2603

---

Performance tuning( what you did in performance tuning)

1987

---

Where are the source flat files kept before running the session?

1078

---

What is informatica?

1155

---

Why sorter is an active transformation?

1192

---

r u done any partitions in ur project?

1827

---

How are indexes created after completing the load process?

1644

---

Which development components of informatica have the highest usage?

1043

---

How to load data in informatica ?

1021

---

Explain what is informatica metadata and where is it stored?

1050

---

What is the meaning of decode in informatica?

1122

---

When do you use sql override in a lookup transformation?

1099

---

What is a snowflake schema?

995

---

What is meant by lookup transformation?

1110

---

What is Session and Batches?

1108

---