how u know when to use a static cache and dynamic cache in
lookup transformation.
Answer Posted / 24/12/2007
if you need the source data after look up transformation to
transfer any other transformation more than once you can use
dynamic cache otherwise use static cache
Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
How to extract sap data using informatica? What is abap? What are idocs?
What is flashback table ? Advance thanks
What is Session and Batches?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the benefit of partitioning a session?
How would you copy the content of one repository to another repository?
What are the static cache and dynamic cache in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain how many types of dimensions are available in informatica?
What are the guidelines to be followed while using union transformation?
Explain in detail about scd type 1 through mapping.
Why do you use Mapping Parameter and mapping variable?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?