from Source 100 rows are coming, on target there are 5 m rows which options is

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

Question Posted / achoudhr

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

Static Lookup on TARGET

Is This Answer Correct ?

1 Yes

6 No

More Informatica Interview Questions

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

How to generate sequence numbers without using the sequence generator transformation?

Without source how to insert record to target?

Do you have knowledge in ralph kimball methodology

Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

Can informatica load heterogeneous targets from heterogeneous sources?

What is staging area?

How to do Integration testing in Informatica?

What does update strategy mean, and what are the different option of it?

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

what is materialized view?

Please let me know how to make Data masking in informatica..

For more Informatica Interview Questions Click Here