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


Please Help Members By Posting Answers For Below Questions

How to load data in informatica ?

590


What are the advantages of informatica?

586


Reusable transformation and shortcut differences

1396


if we have a delimiters at unwanted places in a flat file how can we over come those.

1578


what is informatica metadata?

614






State the limitations where we cannot use joiner in the mapping pipeline?

561


In which transformation you cannot drag ports into it?

814


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 .

1481


How do you promote a non-reusable transformation to reusable transformation?

673


How to update or delete the rows in a target, which do not have key fields?

663


What is sorter transformation?

601


Can we create a node as a gateway node and the same node can be assigned to a grid?

649


What is a dimensional model?

592


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

708


How to generate sequence numbers using expression transformation?

658