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
- 10982 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 could be the possible resons of locks by user?
Can u generate reports in Informatica?
What is the difference between STOP and ABORT options in Workflow Monitor?
How to load the data from a flat file into the target where the source flat file name changes daily?
Can you use flat files in Mapplets.
Explain about Informatica server process that how it works relates to mapping variables?
which one is better performance wise joiner or look up
How can you validate all mappings in the repository simultaneously?
define galaxy repository in informatica
Differentiate between a database and data warehouse?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain the different lookup methods used in informatica?
how to create user defined function (udf) in informatica
update strategy transformation in informatica
Define Pmrep command?
