I wanted to ask, why Static is better than other 3 options.

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

Answer Posted / achoudhr

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between STOP and ABORT options in Workflow Monitor?

1309

How to extract sap data using informatica? What is abap? What are idocs?

1251

What are the differences between a connected lookup and unconnected lookup?

1124

What are the different clients of powercenter?

1114

what is the complex transformation you used in informatica

2623

What is a snowflake schema?

1045

What is aggregate cache in aggregator transformation?

1201

How do you convert single row from source into three rows into target?

1211

What is powercenter on grid?

1227

Explian the Process of deployment groups in informatica

1102

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

1058

What is union transformation in informatica?

1192

What do you mean by enterprise data warehousing?

1108

Explain joiner transformation in informatica

1171

How would you join a node to the already existing domain?

1180