How you know when to use a static cache and dynamic cache in lookup transformation?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  


How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  


difference between repository database and repository service?

0 Answers  


How might you approve all mappings in the archive all the while?

0 Answers  


What is lookup change?

0 Answers  






Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,


In any project how many mappings they will use(minimum)?

1 Answers  


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

0 Answers   Amazon,


What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  


in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,


what is semi-additive fact?where did u used?

2 Answers  


What happens if we dont select data driven option?

2 Answers   Zensar,


Categories