1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach
Answer Posted / sreenu
Unconnected lkp is used for the performance preps bcz hear
we can return only one port and also it is not participated
in mapping directly in ulkp we can use only static cache.
Static cache: static cache is used in unconnected lkp, once
the data is cached it won’t modified.
Dynamic cache: in connected lkp we can use dynamic lkp. By
the use of dynamic lkp we can capture the changed
data.becage dynamic cache is automatically update the
cached data
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to load data in informatica ?
What are the advantages of informatica?
Reusable transformation and shortcut differences
if we have a delimiters at unwanted places in a flat file how can we over come those.
what is informatica metadata?
State the limitations where we cannot use joiner in the mapping pipeline?
In which transformation you cannot drag ports into it?
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 .
How do you promote a non-reusable transformation to reusable transformation?
How to update or delete the rows in a target, which do not have key fields?
What is sorter transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is a dimensional model?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How to generate sequence numbers using expression transformation?