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 tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

---

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

---

How we can confirm all mappings in the repository simultaneously?

1 Answers  

---

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,

---

How to load data in informatica ?

0 Answers  

---

what type of problem you faced insales project or insurance project

1 Answers   Sony,

---

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  

---

What are the ETL tools available in DWH?

6 Answers   Mphasis,

---

what is index?how it can work in informatica

0 Answers  

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---