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?/
Answer Posted / rk
use lookup override as
select *from emp minus select *from emp where rownum<=2
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
where to store informatica rejected data? How to extract the informatica rejected data?
How to update a particular record in target with out running whole workflow?
Mention few advantages of router transformation over filter transformation.
what is index?how it can work in informatica
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How is union transformation utilized?
What is rank transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
what is the -ve test case in your project.
Where are the source flat files kept before running the session?
what are the deliverables?in your project?
What is informatica powercenter repository?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the cumulative sum and moving sum?
How to join three sources using joiner?