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
- 12599 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 is informatica worklet?
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
how to get the first row without using rank t/r?
what is the flow?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
how to return multiple columes through through un-connect lookup?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
State the limitations where we cannot use joiner in the mapping pipeline?
what are the types of Data warehousing ?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the different threads in DTM process?
Teradata 
