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 is the difference between bitmap and btree index?

2 Answers   CTS, TCS,


What is status code?

2 Answers  


Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,


what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,


hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  


What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,


What can we do to improve the performance of informatica aggregator transformation?

0 Answers  


what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  


how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,


4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,


Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  


what transformations are used for Variable port?

2 Answers  


Categories