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
- 11339 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the advantages of using informatica as an etl tool over teradata?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Which transformation is needed while using the Cobol sources as source definitions?
How to do the error handling of if ur source is flatfiles?
What does command task mean?
what are the Methods For Creating Reusable Transformations?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Why sorter is an active transformation?
What is lookup transformation?
Write the advantages of partitioning a session?
what is Active lock explain
What are the tuning techniques you applied during your last project
What are batches?
What is the way to execute pl/sql script using informatica mapping?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
