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...


Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.

Answers were Sorted based on User's Feedback



Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data..

Answer / rajasekhar.

we can create a parameter file as previous_run_time and
current_run_time in the mapping. based on this time stamps
we can capture the new records which need to be insert and
update in the target table.

Is This Answer Correct ?    6 Yes 0 No

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data..

Answer / amarnath

pass the records to the lokup transformation. u get a new
lookup port, pass this to router. in router 1st condition
newlookuprow =0 second newlookuprow =1. pass the "0" to
update strategy for update and pass the "1" to another
update strategy for insert.

Is This Answer Correct ?    4 Yes 4 No

Post New Answer

More Informatica Interview Questions

What are the types of presistent cache in look up tr.

0 Answers   IBM,


Can you start a batches with in a batch?

1 Answers  


What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,


how to convert the .doc docs into .txt format using informatica

4 Answers  


I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,


how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,


i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,


what are the difference between Informatica 7.1 and 8.1?

6 Answers  


Explain the mapping variable usage example in informatica

0 Answers   Informatica,


can a port in expression transf be given the name DISTINCT

3 Answers  


If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,


suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,


Categories