When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
Answer Posted / 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 |
Post New Answer View All Answers
What are the conditions needed to improve the performance of informatica aggregator transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
how to load rows into fact table in data warehouse
What does cheating measurement mean?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are some examples of informatica etl programs?
Under what condition selecting sorted input in aggregator may fail the session?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is incremental aggregation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is a grid in Informatica?
Explain your project of banking domian.