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 partition the Session?
What does command task mean?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
When will you use SQL override in a lookup transformation?
What is the capacity of power cube?
What is the difference between source qualifier transformations source filter to filter transformation?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
How the Informatica Server reads perameter file?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?