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
- 10638 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 |
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
create a mapping to retrieve the employees who are getting salary greater than average salary?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
what is the hint? how to use it to reduce the query processing in program?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
tell me 7.x and 8.x diferrencess(but not transformations)
Write the unconnected lookup syntax and how to return more than one column.
How to prepared lld.can any one tell me detailed explanetion.
What is informatica? Why do we need it?
How to create Target definition for flat files?
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
Teradata 
