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 |
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
In which circumstances that informatica server creates Reject files?
what is runtime variable?
In joiner, how to load Master table in Target?
Reusable transformation and shortcut differences
what is the difference between Informatica7.1 & informatica 8.1
Why you use repository connectivity?
How to generate sequence numbers?
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
how do u tune queries?
How to view and Generate Metadata Reports?
how can we run workflow with pmcmd?