Static Lookup on TARGET

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

Answer Posted / srinu

Is This Answer Correct ?

1 Yes

6 No

Please Help Members By Posting Answers For Below Questions

can u give example for factless fact table

6780

What are the types of caches in lookup? Explain them.

1011

What is domain and gateway node?

1205

Define enterprise data warehousing?

1257

Explain how to import oracle sequence into informatica?

1071

What is meant by active and passive transformation?

1191

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2300

What are some examples of informatica etl programs?

984

What is blocking transformation?

1187

Did u used latest transformations of 8.6.0? for what?

1924

Differentiate between source qualifier and filter transformation?

1631

Can we create two repositories on same database instance in oracle?

1142

How to elaborate tracing level?

1217

What is lookup transformation?

1093

What is a dimensional model?

1033