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
- 14561 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 meant by lookup transformation?
What is pmcmd command?
Difference between Target-based loading and constraint-based loading?
Explain the shared cache and re-cache?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
tell me about your project functionality
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How can we handle two sessions in informatica?
Informatica settings are available in which file?
What is enterprise data warehousing?
What is a joiner transformation and why it is an active one?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How many numbers of sessions can one group in batches?
What is a standalone command task?
