If you configure lookup TRFM to use dynamic cache, then u can use only =

Diffrence between static and dynamic cache

Question Posted / sushma

2 Answers
6461 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / sushma

If you configure lookup TRFM to use dynamic cache, then u
can use only = operator in the lookup condition,whereas LKP
TRFM using static cache can use any relational operator in
the lookup condition.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Mention a few design and development best practices for informatica?

1000

What is the sequence generator transformation in informatica?

1185

What is an unconnected transformation?

1087

What is parallel processing in informatica?

1718

What is the maplet?

1127

How can you define user defied event?

1032

Explain load alternative records / rows into multiple targets - informatica

1157

how tokens will generate?

2207

Explain the shared cache and re-cache?

1121

Define joiner transformation?

1053

What are the differences between joiner transformation and source qualifier transformation?

1176

How does a sorter cache works?

1075

What is a stored procedure transformation?

1056

What is the need of an ETL tool?

1103

what are factless facts? And in which scenario will you use such kinds of fact tables.

1811