When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
- 3 Answers
- 11977 Views
- I also Faced
- E-Mail Answers
Answer Posted / veera
When/Under what circumstances do we use dynamic and static
cache in connected
lookup?
When/Under what circumstances do we use static cache in
unconnected lookup?
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
explan ur project architecture?
How do you migrate data from one environment to another?
What is a stored procedure transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is a router transformation?
How many number of sessions can one group in batches?
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
Differentiate between Load Manager and DTM?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
list out all the transformations which use cache?
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?
How do you change a non-reusable transformation to reusable transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Describe expression transformation?
