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 Default Source Option For Update Strategy Transformation?

757

what is the complex transformation you used in informatica

2192

What are Dimensional table?

619

What is xml source qualifier transformation in informatica?

714

Describe data concatenation?

574

What is a filter transformation?

570

Can informatica load heterogeneous targets from heterogeneous sources?

697

What is sorter transformation?

585

What are the different clients of powercenter?

602

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

1941

Difference between Target-based loading and constraint-based loading?

554

How do you load unique records into one target table and duplicate records into a different target table?

712

What all are steps in up gradation of Informatica server?

622

Describe expression transformation?

636

What is sq transformation?

668