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 to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1599

---

What is an expression transformation in informatica?

514

---

What is update strategy transform?

566

---

What is a node in Informatica?

618

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1864

---

---

How can you define user defied event?

614

---

can you please explain me pre session and post session options?

6358

---

What is the scenario which compels informatica server to reject files?

599

---

Tell me about Propagate functions in informatica

520

---

How can we update a record in the target table without using update strategy?

649

---

Explain the different dimensions.

548

---

What is incremental aggregation?

570

---

What is joiner transformation?

581

---

What are the transformations that are not supported in mapplet?

593

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

611

---