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
How to start a workflow using pmcmd command?
explan ur project architecture?
Explain about Informatica server process that how it works relates to mapping variables?
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 are the types of schemas we have in data warehouse and what are the difference between them?
What are the mapping parameters and mapping variables?
Explain Dataware house architecture .how data flow from intial to end?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is data caches/ index caches?
What does “tail –f” command do and what is its use as an Informatica admin.
How to do unit testing in informatica?
What if the source is a flat-file?
without table how to come first record only in oracle?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Briefly explain the aggregator transformation?