Interested to Buy Any Domain ? << Click Here >> for more details...
source table have 3 records? and it is sucessfully loaded
into target. and 4more records is added in to source .that
means 7 records now in source. we have to load the
remaining 4 records into the same trgt table with maintian
top 3 records. how ?can any one give me the data flow of
this logic plz?
- 5 Answers
- 10729 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / vinod
Use Update Strategy Transformation. Identity an unique
field or an unique combination which is the primary key.
Check the primary key field or combination field in Update
stratergy based on which the target is updated. If the key
from the source matches with the target key field, then
these rows not inserted into the target, else it gets
inserted
Correct me if I am wrong
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is sequence generator transformation in informatica?
What is the benefit of session partitioning?
How does a sorter cache works?
What is the fact table?
How to load the data from a flat file into the target where the source flat file name changes daily?
How can you increase the performance in joiner transformation?
can we override a native sql query within informatica? How do we do it?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the difference between a connected look up and unconnected lookup?
What is incremental aggregation?
What is sq transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the differences between joiner transformation and source qualifier transformation?
