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
- 14810 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
Define enterprise data warehousing?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is the command used to run a batch?
How many number of sessions can one group in batches?
What is meant by lookup transformation?
explain abt ur project architecture?
Explain direct and indirect flat file loading (source file type) - informatica
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to load last n records of file into target table - informatica
is it possible to index the data in cache of lkp transformation ?
what is INFORMATICA TESTING process
Explain joiner transformation in informatica
During the running session, output files are created by informatica server. Enlist few of them.
How might you approve all mappings in the archive all the while?
Did u used latest transformations of 8.6.0? for what?
