Interested to Buy Any Domain ? << Click Here >> for more details...
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?/
- 5 Answers
- 12781 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rk
use lookup override as
select *from emp minus select *from emp where rownum<=2
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / rambabu
Hi gurpreet, we cant use > simble with romnum,
the answer given by RK is obsolutly correct
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sujana
create a flatfile for 1st and 2nd records...keep lukup on dis table..if condition doesnt match it inserts the record (use not equal operator in condition)..
crct me if im wrong
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / gurpreet
select from emp where rownum> 2;
se this in sql override
| Is This Answer Correct ? | 1 Yes | 9 No |
can a port in expression transf be given the name DISTINCT
what happens when a batch fails?
what is materialized view?
why normalizer transformation can not used in mapplet? plzzzz answer
How to run a session, which contains mapplet?
How many ways you create ports?
To achieve the session partition what r the necessary tasks u have to do?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
Do you find any difficulty while working with flat files as source and target?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the reusable transformation?
Teradata 
