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
- 10910 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 uses of etl tools?
What are the different components of powercenter?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How do you change a non-reusable transformation to reusable transformation?
Can we create a Integration service without a Repository service and vice versa?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What happens when a session fails and you click on recover?
How will the document be delivered to me?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain pushdown optimization $pushdownconfig parameter - informatica
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
