how u know when to use a static cache and dynamic cache in
lookup transformation.

Answer Posted / nisith

Dear,

Whenever you required changes in your target as a lookup
than go for dynamic.Static means its a readonly why do u
want your server to busy..so stick on static only
comparison is there thats it....

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does cheating measurement mean?

601


tell me 5 session failure in real time how can you solve that in your project?

1634


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

742


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1699


What is the difference between writing a joiner query in ANSI style and THETA style?

1925






How can you generate reports in informatica?

584


How do you manage the Parameter files while migrating your data from one environment to another environment?

555


What are the mapping parameters and mapping variables?

624


How would you join a node to the already existing domain?

683


What is a rank transform?

678


During the running session, output files are created by informatica server. Enlist few of them.

546


Define Pmrep command?

642


where to store informatica rejected data? How to extract the informatica rejected data?

607


Difference between Target-based loading and constraint-based loading?

557


What is the need of an ETL tool?

644