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

how to delete duplicate records by using filter transfermation?

3 Answers  

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,

what is threshold error in informatica?

1 Answers   TCS, Wipro,

What are the join types in joiner transformation?

1 Answers   Informatica,




What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  

How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,

For more Informatica Interview Questions Click Here
Categories