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

Differences between connected and unconnected lookup?

0 Answers  

In session log thier should not be a single error how will u do

3 Answers   HCL,

What are the different threads in DTM process?

2 Answers  

what is lookup ?

7 Answers  

What is sql query override? When did u use sql query override?

1 Answers   TCS,

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

Explain transaction control transformation in informatica

0 Answers   Informatica,

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

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  

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

What do mean by local and global repository?

0 Answers  

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories