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
- 11431 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 |
What are the prerequisite tasks to achieve the session partition?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is a node in Informatica?
can we use self join in informaitca?
If we have lookup table in workflow how do you trouble shhot to increase performance?
How many mapplets u have created? and what is the logic used
how can import the data from the flat files?
Is stop and abort are same in informatica?
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
How to create or import flat file definition in to the warehouse designer?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
How does a rank transform differ from aggregator transform functions max and min?
Teradata 
