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

Explain the different dimensions.

913

---

Explain the tuning lookup transformation - informatica

951

---

What is the use of code page?

1010

---

explain abt ur project architecture?

2122

---

What are junk dimensions?

1020

---

Mention some types of transformation?

991

---

What are the types of caches in lookup?

975

---

What is mapplet in informatica?

982

---

What is sq transformation?

1080

---

What are pre and post-session shell commands?

1236

---

How can you validate all mappings in the repository simultaneously?

1287

---

What do you mean by worklet?

1017

---

How many dimensions are there in informatica?

1023

---

What is incremental aggregation?

1014

---

What is the need of an ETL tool?

1027

---