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
- 14796 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / himanshu
1. Lookup Transformation (Dynamic lookup 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 ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain the features of connected and unconnected lookup.
What could be the possible resons of locks by user?
What are the new features of Power Center 5.0?
What is complex mapping?
What is difference between a gateway node and worker node?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Which files are created during the session rums by informatics server?
COM components can be used in Informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is union transformation in informatica?
What is meant by query override?
explain one complex mapping with logic? sales project?
What do think which one is the better joiner or look up?
Describe expression transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
