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


Please Help Members By Posting Answers For Below Questions

Which are the different editions of informatica powercenter that are available?

557


What are the different types of repositories created using informatica?

655


hi real timers . iam waiting for ur reply regarding ETL TESTING

1804


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1553


Under what conditions selecting sorted input in aggregator will still not boost session performance?

632






Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1932


What is joiner change?

674


What is meant by pre and post session shell command?

621


tell me about your project functionality

1864


What is enterprise data warehousing?

613


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

598


What are the informatica performance improvement tips

611


Explain how to import oracle sequence into informatica?

590


How does the aggregator transformation handle null values?

697


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1529