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
- 11528 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 |
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
What is the function of union transformation?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
What are mapplets?
Is it possible to have "5 source & 5 Target" in single mapping?
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve
in which situations do u go for scds ?
What is the Rankindex in Ranktransformation?
What is a transaction control transformation?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
What is the query to find nth highest salary? What is the use of cursors?
Teradata 
