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

What is the different lookup cache(s)?

1086

What is informatica metadata and where is it stored?

991

Differentiate between joiner and lookup transformation?

1102

What are the settings that you use to configure the joiner transformation?

1055

In how many ways we can create ports?

1123

generate date / time dimension in informatica

1125

How can we use mapping variables in informatica? Where do we use them?

1200

How to improve the performance of a session using sorter transformation?

1146

my source is junk data how will u remove that junk data by using unix please any one replay me

3704

Differentiate between source qualifier and filter transformation?

1578

complex mapping ur project u r invlve can u explain and give real time example give me ?

2298

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

2395

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1199

What do you understand by term role-playing dimension?

1048

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

1052