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
- 13222 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
How to open an older version of an object in the workspace?
What is sequence generator transformation in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is pmcmd command?
How to generate sequence numbers using expression transformation?
How can you validate all mappings in the repository simultaneously?
Explain why we use partitioning the session in informatica?
How many input parameters can exist in an unconnected lookup?
How to create or import flat file definition in to the warehouse designer?
What are the static cache and dynamic cache in informatica?
What are the informatica performance improvement tips
What is meant by LDAP users?
what are 3 tech challenges/ common issues you face?
What is the procedure for creating independent data marts from informatica 7.1?
