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

Explain incremental aggregation in informatica

0 Answers   Informatica,

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,

what is data driven?

5 Answers   TCS, Wipro,

Is it possible to use a client with different version than that of its Informatica server?

0 Answers  

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  

What is the session task and command task?

0 Answers  

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

what is incremantal aggregation?

1 Answers  

For more Informatica Interview Questions Click Here
Categories