When do we use dynamic cache and static cache in connected and unconnected loo

When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?

Question Posted / guest

3 Answers
12754 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?..

Answer / vinod saini

Dynamic cache uses for updation of Master Table & SCD type 1
Static uses for Flatfile

Is This Answer Correct ?

3 Yes

0 No

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?..

Answer / veera

When/Under what circumstances do we use dynamic and static
cache in connected
lookup?
When/Under what circumstances do we use static cache in
unconnected lookup?

Is This Answer Correct ?

1 Yes

2 No

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?..

Answer / bc

we can use dynamic and static cache in connected
lookup..and we can use only static cache in unconnected
lookup.

Is This Answer Correct ?

0 Yes

4 No

Post New Answer

More Informatica Interview Questions

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers Infosys,

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers

How can we remove the duplicates from flat file source?

0 Answers

Where do you create/define mapping parameter and mapping variable?

1 Answers

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers IBM,

What are differences between Informatica 7.1 and 6.1

3 Answers

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers Puma,

What are the types of caches in lookup?

0 Answers

What are the two modes of datamovement in informatica sever?

2 Answers

Explain why we use partitioning the session in informatica?

0 Answers

What is persistent lookup cache?

0 Answers

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers IBM,

For more Informatica Interview Questions Click Here