how u know when to use a static cache and dynamic cache in
lookup transformation.
- 9 Answers
- 25224 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / abhsihek
Hi neetu,
as i know that dynamic lookup alway increase the perfomence
compratively static cache if i am wrong please let me know.
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What is olap (on-line analytical processing?
What is Data Caches size?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
In how many ways we can create ports?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is meant by incremental aggregation?
On which transformations you created partitions in your project?
whats the logic to load the lower level of granularity of data to fact table.
In development project what is the process to follow for an etl developer from day1
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Describe data concatenation?
Please let me know how to make encryption and decryption with example?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Write the prerequisite tasks to achieve the session partition?
Whats there in global repository
