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

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

What is the use of source qualifier?

0 Answers  

which transformation uses cache?

3 Answers   Keane India Ltd,

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,

What is standalone command task?

0 Answers  

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,

What is dynamic cache?

0 Answers  

What is galaxy shema

2 Answers   CGI,

what is the incremental agrrigation?

2 Answers   Cap Gemini,

in which situations do u go for sequence generator ?

2 Answers   TCS,

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

For more Informatica Interview Questions Click Here
Categories