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

Hi All, i have question regarding Change Data Capture in
Informatica. As i know we can do this using Incremental
Aggregation(i never worked on Informatica but i read) and i
think we can do the same with SQL Over write and with
variables. Can someone tell me how do we do this using
other two techniques.. using SQL Over write and variables.

Thanks for the help and greatly appreciated.

Question Posted / krishraj


Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this usi..

Answer / rajesh_audhi

If u have audit columns in the source like load_date we can
easily captured the changed data.we will extract only
changed data thru a query override in source qualifier by
giving like load_date>$$load_date.$$load_date is a mapping
variable which we set this value to the max(load_date)
during run time of session.so that it will store
max(load_date) in the variable and next time when we run the
same mapping it will fetch the source rows based on the
condition load_date>$$load_date.we will set this $$load_date
to max value using setmaxvalue function in any expression
transformation.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

which one is better either active or passive transformation in informatica

1 Answers  

What are the reusable transformations?

0 Answers   Informatica,

What are multi-group transformations?

0 Answers   Informatica,

Write the different tools in the workflow manager?

0 Answers  

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

What is xml source qualifier transformation in informatica?

0 Answers  

Quickly characterize reusable change?

0 Answers  

is it possible to index the data in cache of lkp transformation ?

0 Answers  

Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

For more Informatica Interview Questions Click Here
Categories