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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What is CDC? How to implement CDC?

Question Posted / suraj.kedia07

Answers were Sorted based on User's Feedback



What is CDC? How to implement CDC?..

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.

Is This Answer Correct ?    11 Yes 7 No

What is CDC? How to implement CDC?..

Answer / reddy

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

Is This Answer Correct ?    4 Yes 0 No

What is CDC? How to implement CDC?..

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

Is This Answer Correct ?    1 Yes 0 No

What is CDC? How to implement CDC?..

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.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

How to do the error handling of if ur source is flatfiles?

0 Answers  

how we do performence tuning in informatica

3 Answers  

where is the reject loader .

1 Answers  

How to get EVEN & ODD numbers separately?

8 Answers  

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

7 Answers   iNautix,

For more Informatica Interview Questions Click Here
Categories