1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How can one identify whether mapping is correct or not without connecting session?
in realtime which situations u can use unconnected lookup transformation
What is domain and gateway node?
how to get max value record into one target and remaining records into another target?
how to import multiple flat files in to single target where there is no common column in the flat files
What are connected or unconnected transformations?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
What are events in workflow manager?
What is mapplet and a reusable transformation?
version controlling in informatica?
In which transformation you cannot drag ports into it?