Interested to Buy Any Domain ? << Click Here >> for more details...
S1 is having 1 lakh records and s2 is having 100 records,
s2 should compare s1 if emp no is same data should be
updated if not their it should insert the data.what are the
transformation used?
- 5 Answers
- 14725 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sachin
The pipeline is as follows
sqr->exp->lkp->exp->upd->tgt
Lookup Transformation (Dynamic cache enabled)
Use NewLookUpRow Attribute to determine if it is a
new(1),updated(2) or no change(0) record.
2. Update Strategy
Use condition on NewLookkUpRow value to Insert or Update
the record in the target or Reject it.
IFF(NewlookUpRow = 1, DD_Insert, IFF(NewlookUpRow =
2,DD_Update, DD_Reject))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an expression transformation?
update strategy transformation in informatica
What is target load order?
where to store informatica rejected data? How to extract the informatica rejected data?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How can we delete duplicate rows from flat files?
Why filter transformation is an active one?
What is the difference between stop and abort in informatica
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How can we store previous session logs?
What is the format of informatica objects in a repository?
Explain sql transformation in script mode examples in informatica
What are the differences between a connected lookup and unconnected lookup?
what is index?how it can work in informatica
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
