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
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 |
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 |
What is the difference between bitmap and btree index?
What is status code?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what is the diff b/w cached and unchaed look ups
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
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
What can we do to improve the performance of informatica aggregator transformation?
what is the process we used in joiner transformation,there is no matching column in sources?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
4 yrs etl devloper roles and responsibilities?any body give solutions
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 " ?
what transformations are used for Variable port?