Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?/

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

where to store informatica rejected data? How to extract the informatica rejected data?

1010


How to update a particular record in target with out running whole workflow?

1586


Mention few advantages of router transformation over filter transformation.

1028


what is index?how it can work in informatica

2047


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?

2140


How is union transformation utilized?

1016


What is rank transformation?

997


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2079


what is the -ve test case in your project.

2418


Where are the source flat files kept before running the session?

1094


what are the deliverables?in your project?

2156


What is informatica powercenter repository?

1211


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?

978


What is the cumulative sum and moving sum?

1192


How to join three sources using joiner?

1124