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.

What is meant by target load plan?

0 Answers  

---

How to delete the data in the target table after loaded.

3 Answers   TCS,

---

What are the tasks that can be performed using sq?

0 Answers  

---

what are presession,postsession success and postsession failure commands ?

1 Answers  

---

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

---

What is the Rank index port in Rank transformation?

0 Answers   Informatica,

---

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  

---

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

---

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,

---

how to load rows into fact table in data warehouse

0 Answers   Informatica,

---

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

---

Can you access a repository created in previous version of Informatica?

1 Answers  

---