Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.
- 2 Answers
- 10510 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 join three sources using joiner? Explain though mapping flow.
What is the query to find nth highest salary? What is the use of cursors?
What is different between the data warehouse and data mart?
What is a code page?
Without source how to insert record to target?
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
what is the difference between static and dynamic
Can you use one mapping to populate two tables in different schemas
What is a test load?
What are the new features in Informatica 5.0?
How the dimensions will be loaded?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
Teradata 
