how u know when to use a static cache and dynamic cache in
lookup transformation.
Answer Posted / amit
when we use conneted type of lookup then we use dynamic
caches& when we use unconncted lookup in the modelling we
use static cache
| Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
What is the way to execute pl/sql script using informatica mapping?
What do you mean by channel change?
Explain the difference between mapping parameter and mapping variable?
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
Write the unconnected lookup syntax?
How can we use batches?
Which transformation should we use to normalise the COBOL and relational sources?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
State the differences between sql override and lookup override?
Enlist the differences between database and data warehouse.
What is a standalone command task?
What is resilience time?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How many ways a relational source definition can be updated and what are they?
can u give example for factless fact table