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
- 11004 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
Describe the impact of several join conditions and join order in a joiner transformation?
What is a filter transformation and why it is an active one?
How to generate sequence numbers?
Explain pushdown optimization and types in informatica
how to create user defined function (udf) in informatica
Is it possible to use a client with different version than that of its Informatica server?
What is data transformation manager process?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How to do the error handling of if ur source is flatfiles?
What is blocking transformation?
What is the benefit of session partitioning?
Explain the pipeline partition with real time example?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How do you load only null records into target?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
