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 |
in oracle write query yourname+1 from dual
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
What are the issues you have faced in your project? How did you overcome those issues?
What is the difference between view and materialised view?
What is an expression transformation in informatica?
server hot-ws270 is connect to Repository B. What does it mean?
What is pmcmd command?
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
why we use informatica in our project?