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
Write the advantages of partitioning a session?
What are the types of schemas we have in data warehouse and what are the difference between them?
which one is better performance wise joiner or look up
What is the use of target designer?
What is a predefined event?
How we can use union transformation?
what is the hint? how to use it to reduce the query processing in program?
How we can create indexes after completing the loan process?
What are batches?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the tasks that source qualifier perform?
can u any challenge your project?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is difference between a gateway node and worker node?