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...

I have a scenario with lookup table. in that lookup table have
colomns, but i need to process only 10 colomns out of 50.
Please te me how can we acheive it?

Answer Posted / ankur saini er.ankur861@gmail.

hey...i think we can use dynamic lookup too..in dynamic
lookup mark ignore the columns you dont want them tp
participate in lookup process rest for every port specify a
expression for lookup..

GUYs...let me know your comments on this...

Thanks

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2296


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1200


What is decode in informatica?

1074


What is a rank transform?

1026


Differentiate between router and filter transformation?

954


What are the types of caches in lookup? Explain them.

920


What is data caches/ index caches?

1024


What are junk dimensions?

1021


list out all the transformations which use cache?

1114


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2032


Plz can any one say me how to get the informatica certification materials and dumps

2000


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1631


what is the size of your data warehousing?

2044


tell me about your project functionality

2295


What is the sequence generator transformation in informatica?

1096