Interested to Buy Any Domain ? << Click Here >> for more details...
Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.
- 2 Answers
- 11660 Views
- I also Faced
- E-Mail Answers
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 work with mapplet designer in informatica?
What are the various types of transformation?
Design a mapping to load a target table with the following values from the above source?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
major difference between normal loading and bulk loading?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
How to elaborate powercenter integration service?
how to obtain performance data for individual transformations.
what is mean by flag 4 in update strategy t/r
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
what is system requirement(SR) & business requirement(BR)?
how do the project develops? pls specify right from the start to end in step by steps.
Teradata 
