Answer / bharu_295

hi cdc stands for capture data change.

it is done by using incremental loading of the source data.

ex: in source take a column modified date

in mapping take sysdate as one column and get data with modifieddate>sysdate. condition.

Answer / reddy

CDC Stands for Change Data Capture. All Changed
transactions will be moved from Source system to
destination through Archive Logs.

Answer / seshu

The Informatica PowerExchange CDC Option captures changes
in a number of environments as they occur, satisfying
business requirements for up-to-the-minute data and
increasing business agility

Answer / 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 can we handle two sessions in informatica?

0 Answers  

---

What is data merging,data cleansing,sampling?

4 Answers  

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

---

what is the incremental agrrigation?

2 Answers   Cap Gemini,

---

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

---

What is the difference between a table and the materialized view?

2 Answers  

---

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

---

How to load time dimension?

1 Answers   Ford,

---

what is materialized view?

2 Answers  

---