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 what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1039

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1116

---

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

1065

---

What is update strategy transform?

1096

---

How can you validate all mappings in the repository simultaneously?

1361

---

How many transformations can be used in mapplets.

1928

---

How do you load first and last records into target table?

1152

---

What are the different transaction levels available in transaction control transformation?

1191

---

Explain the features of connected and unconnected lookup.

929

---

What is the meaning of decode in informatica?

1118

---

Explain in detail scd type 2 through mapping.

1037

---

How to join three sources using joiner? Explain though mapping flow.

1140

---

which one is better performance wise joiner or look up

1082

---

What is decode in static cache?

1169

---

What is a connected transformation?

1113

---