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
- 12581 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 |
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
how to identify new and old values in source qualifier or any other transformations using informatica
Explain reference cursor?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
explain about session partitions ?
why sequence generator should not directly connected to joiner transformation ?
What is meant by active and passive transformation?
How do you handle two sessions in Informatica
Can you use flat files in Mapplets.
difference between shortcut and reusable transformation?
Explain your project of banking domian.
In real time scenario where can we use mapping parameters and variables?
Teradata 
