1.why we need to use unconnected transformation? 2.where we can static chach,dy

1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach

Question Posted / mohanreddy

4 Answers
11093 Views
Virtusa, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach..

Answer / rahul

In Lookup transformation;
Unconencted is used when ever u want to call the same
transformation several times and u have one return port.

Use dynamic cache if u want to update the case while
updating the target table itself and static is untouched
with the cache.

Is This Answer Correct ?

6 Yes

1 No

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach..

Answer / 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

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach..

Answer / satyam

We use an unconnected transformation when we need one
return column from each row and it receives values from:
LKP expression from another transformation.

Is This Answer Correct ?

1 Yes

0 No

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach..

Answer / tanay

1.We use unconnected transformation to use multiple number
of tables or views without physically taking the entity
into mapping.This kind of transformation is also helpful
when single return port is required.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer