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 / jack

Lookup SQL override will help you to achieve this

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can anyone tell me the new features in Informatica 9 Version?

1534


Did u used latest transformations of 8.6.0? for what?

1481


Explain the features of connected and unconnected lookup.

548


how to create user defined function (udf) in informatica

789


How many numbers of sessions can one group in batches?

625






Explain informatica architecture - version 8 / 9

675


What are the types of caches in lookup?

578


What is a predefined event?

662


What is meant by pre and post session shell command?

628


what are the Methods For Creating Reusable Transformations?

652


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1702


Define joiner transformation?

598


How does the aggregator transformation handle null values?

703


Explain sql transformation in script mode examples in informatica

609


What is domain and gateway node?

702