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

What is the maplet?

1198

---

How to do the error handling of if ur source is flatfiles?

2011

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2288

---

How do you load only null records into target?

1249

---

What is a rank transform?

1135

---

What all are steps in up gradation of Informatica server?

1093

---

Explain pmcmd command usage in informatica

1180

---

According to his methodology what all you need before you build a datawarehouse

1798

---

what is the difference between informatica6.1 and infomatica7.1

2356

---

What are the measure objects?

1250

---

what is $$$$?

2199

---

How to elaborate powercenter integration service?

1172

---

While migrating the data from one environment to another environment how would you manage the connections?

1125

---

Does an informatica transformation support only aggregate expressions?

1082

---

Explain the types of transformations?

1094

---