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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

Question Posted / ankit kansal

Answer Posted / ankit kansal

Unconnected Lookup is a better option as It will fire a sequel query whenever it was being called from other transformation using :LKP.lkp_trans(fieldname).

Or

Create a persistence cache for that table if it's not getting updated frequently. and use this cache in different other jobs.

http://deepinopensource.blogspot.in/

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explian the Process of deployment groups in informatica

988

What is the difference between stop and abort in informatica

1041

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1131

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1163

How to differentiate between the active and passive transformations?

1068

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1873

Briefly define reusable transformation?

1074

Explain what are the different types of transformation available in informatica.

1036

What is source qualifier transformation in informatica?

942

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

2290

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1104

draw informatica architecture 8.6 ?

3817

Why union transformation is an active transformation?

992

How do you migrate data from one environment to another?

1041

What is domain in terms of informatica?

951