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

Why update strategy and union transformations are active? Explain with examples.

0 Answers  

What is the meaning of up gradation of repository?

0 Answers  

What are the reusable transforamtions?

2 Answers  

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  

What is the advantage of informatica?

0 Answers  

How many dimensions are there in informatica?

0 Answers  

For more Informatica Interview Questions Click Here
Categories