because all rows from the master table are loaded into the cache,so that it

Why we select the table which has minimum number of records
as Master table in joiner?

Question Posted / balaswamy

Answer Posted / balaswamy

because all rows from the master table are loaded into the cache,so that it will take up the least amount of space in the
cache

Is This Answer Correct ?

15 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the scenario which compels informatica server to reject files?

1091

Explain the different kinds of facts.

935

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1806

What is status code in informatica?

959

What do you mean incremental aggregation?

1013

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1999

What is meant by query override?

1008

Different circumstance which drives informatica server to expel records?

918

Can we create a node as a gateway node and the same node can be assigned to a grid?

1028

Separate from a database, an information bazaar, and an information stockroom?

1014

What is event and what are the tasks related to it?

1057

Explain the aggregator transformation?

1096

Did u used latest transformations of 8.6.0? for what?

1825

What is persistent lookup cache?

969

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1052