Coolboy answer is correct , if you just want to join. When u want to upd

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 / kt

Answer Posted / kt

Coolboy answer is correct , if you just want to join.

When u want to update the target then we hsould use DYNAMIC
cache.

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1056

How to use procedural logic inside infromatica?

1247

What is the use of an aggregator cache file?

1199

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1906

What is the use of transformation?

1000

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2400

Explain transaction control transformation in informatica

1271

Which is the t/r that builts only single cache memory?

1190

What is enterprise data warehousing?

1049

How might one distinguish in the case of mapping is right or not without associating session?

1129

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1070

What are the main issues while working with flat files as source and as targets ?

1165

How do you set a varible in incremental aggregation

1892

How to extract the informatica rejected data?

1223

What is the Process to creating lookup transformation in informatica

1046