Answer Posted / abhinaw prakash

CDC is changed data capture.
We can implement the same in Informatica using a filter transformation and passing only the Incremental rows.
A better option in this would be to dynamically create a parameter file every time the workflow runs and using the its value in the filter expression.

how many types of dimensions are available in informatica?

997

---

How does the aggregator transformation handle null values?

1085

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7314

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

915

---

Design time, run time. If you don't create parameter what will happen

1795

---

What is a repository manager?

1029

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1020

---

Define mapping and session?

968

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1442

---

Could you explain what is enterprise data warehouse?

1047

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1628

---

Please let me know how to make encryption and decryption with example?

1846

---

What is DR strategy for Informatica project?

1114

---

What is a surrogate key?

1016

---

Did u used latest transformations of 8.6.0? for what?

1823

---