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 batch and describe about types of batches?

2 Answers  

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

what are the difference between Informatica 7.1 and 8.1?

6 Answers  

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

What is the status code?

1 Answers  

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

What is a difference between complete, stop and abort?

0 Answers  

What is meant by lookup transformation?

0 Answers  

What is a sequence generator transformation?

0 Answers  

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

For more Informatica Interview Questions Click Here
Categories