from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data

1. Joiner
2 No cache
3. Static
4. Dynamic

Answers were Sorted based on User's Feedback



from Source 100 rows are coming, on target there are 5 m rows which options is better to match dat..

Answer / srinu

Static Lookup on TARGET

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More Informatica Interview Questions

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,


How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,


how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,


Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  


Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  






checkout and checkin in informatica 8.6

3 Answers   TCS,


if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,


Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,


How does the aggregator transformation handle null values?

0 Answers  


What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  


How can we use mapping variables in informatica?

0 Answers  


Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  


Categories