What are the types of lookup caches?
Answer Posted / venkat
1)Static cache
2)Dynamic cache
3)Recache
4)Persistent cache
5)Reusable cache
6)Sequential cache
7) Concurrent cache
8)Shared cache
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain pushdown optimization and types in informatica
What are the different lookup cache(s)?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Differentiate between a database and data warehouse?
What do you mean by enterprise data warehousing?
Explain target update override in informatica
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 .
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the databases that informatica can connect to windows?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is sorter transformation?
Explain the different lookup methods used in informatica?
Define enterprise data warehousing?