Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

---

What is meant by active and passive transformation?

0 Answers  

---

What is different between the data warehouse and data mart?

0 Answers  

---

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

---

---

What is informatica? Why do we need it?

0 Answers  

---

What are the limitations of joiner transformation?

0 Answers   Informatica,

---

explan ur project architecture?

0 Answers   TCS,

---

What is a dimensional model?

0 Answers  

---

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

Explain the features of connected and unconnected lookup.

0 Answers  

---