Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is CDC? How to implement CDC?

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.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by SOA of Informatica?

981


Is it possible to revert a global repository to local one and why?

1078


Suppose we do not group by on any ports of the aggregator what will be the output?

1041


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1244


What is substr in informatica?

1203


What is the different lookup cache(s)?

1082


What is a rank transform?

1083


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2073


What is aggregator transformation in informatica?

939


Briefly define reusable transformation?

1126


How to delete duplicate row using informatica?

1041


Is stop and abort are same in informatica?

995


How to load a Dimension ? and how to load a fact table?

1409


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.

1699


What is sorter transformation?

1041