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
- 10744 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
What are the settings that you use to configure the joiner transformation?
What is a repository manager?
What is the benefit of partitioning a session?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Which transformation should we use to normalise the COBOL and relational sources?
What is meant by query override?
What is blocking transformation?
Differentiate between joiner and lookup transformation?
What do you mean by enterprise data warehousing?
Define Pmrep command?
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 ?
Tell me about MD5 functions in informatica
How to update source definition?
What can we do to improve the performance of informatica aggregator transformation?
