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 / mehul.thakur

Answers were Sorted based on User's Feedback



if i have source with 100 records target with 100 records and we lookup on another database table an..

Answer / srinu

unonnected lookup

Is This Answer Correct ?    4 Yes 3 No

if i have source with 100 records target with 100 records and we lookup on another database table an..

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

More Informatica Interview Questions

Informatica and datawarehousing courses in Pune?

2 Answers  

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

What is the need of building a data warehouse?

2 Answers  

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

how can we run workflow with pmcmd?

3 Answers   Wipro,

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

What is blocking transformation?

0 Answers   Informatica,

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

What is the difference between Normal load and Bulk load?

5 Answers  

What are the types of metadata that stores in repository?

2 Answers  

For more Informatica Interview Questions Click Here
Categories