when we use lookup,if have 5 records,if i dont need 1st and
2nd records..what will be the procedure to achieve by using
lookup?/
Answer Posted / rk
use lookup override as
select *from emp minus select *from emp where rownum<=2
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
What is a surrogate key?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How does a sorter cache works?
What is standalone command task?
What are the measure objects?
What is main use of mapplet?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How can you validate all mappings in the repository simultaneously?
Differentiate between reusable transformation and mapplet.
According to his methodology what all you need before you build a datawarehouse
What is mapping debugger?
Explain the features of connected and unconnected lookup.
What is a filter transformation and why it is an active one?
What are the performance considerations when working with aggregator transformation?