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

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

1 Answers   Accenture,


In which circumstances that informatica server creates Reject files?

2 Answers  


what is runtime variable?

3 Answers   TCS,


In joiner, how to load Master table in Target?

2 Answers  


Reusable transformation and shortcut differences

0 Answers  


what is the difference between Informatica7.1 & informatica 8.1

4 Answers  


Why you use repository connectivity?

3 Answers   Yash Technologies,


How to generate sequence numbers?

0 Answers  


supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,


how do u tune queries?

1 Answers  


How to view and Generate Metadata Reports?

1 Answers  


how can we run workflow with pmcmd?

3 Answers   Wipro,


Categories