2,can we insert duplicate data with dynamic look up cache,if
yes than why and if no why?
Answer Posted / sehaj
DUPLICATE DATA CANOT B INSERTED USIN DYNAMIC LOOK UP
CACHE..BCOZ DYNAMIC LOOK UP CACHE PERFORMS ONLY UPDATE N
INSERT FUNCTION BASED ON THE KEYS IT GETS IN THE TARGET
TABLE N LOOK UP TABLE...
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
How can you differentiate between powercenter and power map?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
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?
Explain informatica architecture - version 8 / 9
Difference between Target-based loading and constraint-based loading?
How to create a non-reusable instance of reusable transformations?
what is diff b/t sorter t/r and agg have the option sorter property...
What is an Integration service in Informatica?
Slowly changing dimensions, types and where will you use them
What is data transformation manager process?
Differentiate between router and filter transformation?
Enlist few areas or real-time situations where informatica is required.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Where are the source flat files kept before running the session?
What are the components of Informatica? And what is the purpose of each?