1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / veera

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a snowflake schema?

573

Differentiate between source qualifier and filter transformation?

1003

What are the prerequisite tasks to achieve the session partition?

714

What are the different types of transformation available in informatica.

639

difference between informatica 8.1.1 and 8.6

3245




How might one distinguish in the case of mapping is right or not without associating session?

642

What all join we can perform in LOOKUP transformation?

569

How to create the source and target database connections in server manager?

633

Mention few advantages of router transformation over filter transformation.

640

how to load dimension table and fact table. plz tell me the steps.

1686

Repository user profiles

1377

In informatica workflow manager, how many repositories can be created?

783

Explain pmcmd command usage in informatica

708

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1539

How to extract the informatica rejected data?

757