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

What is informatica powercenter repository?

What is the procedure to load the fact table.Give in detail?

What is Datadriven?

wht target override?wht advantages it has compare to target update?

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

How would you copy the content of one repository to another repository?

While importing the relational source defintion from database,what are the meta data of source U import?

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

Can anyone tell me the new features in Informatica 9 Version?

How to read data from flat file source if the data is in paragraph format?

explan ur project architecture?

where to select code page option?

For more Informatica Interview Questions Click Here