Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Connected and UnConnected
Lookup Transformation.Give me one or two examples please?
- 7 Answers
- 18387 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
CONNECTED T/S RECIVES MULTIPLEINPUTS AND PROVIDES MULTIPLE
OUTPUTS
SUPPORTS USERDEFINED VALUES
USE DYNAMIC CACHE
AND IF U WANT TO USE THE SAME LOOK UP MULTIPLE TIMES IN
THE MAPPING U CAN GO FOR UNCONNECTED
IT RECIEVES INPUT FROM THE RESULT OF AN EXPRESSION
TRANSFORMATION AND PROVIDES SINGLE OUTPUT
DOES NOT SUPPORT USER DEFINED VALUES
USES STATIC CACHE
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What does command task mean?
Target increases every day even though no new record was inserted
How do you migrate data from one environment to another?
have u done any performance tuning? how u ll do?
r u done any partitions in ur project?
How many types of sessions are there in informatica.please explain them?
How you know when to use a static cache and dynamic cache in lookup transformation?
tell me 5 session failure in real time how can you solve that in your project?
Explain dynamic target flat file name generation in informatica
what is the -ve test case in your project.
What are junk dimensions?
How can a transformation be made reusable?
If informatica has its scheduler why using third party scheduler?
During the running session, output files are created by informatica server. Enlist few of them.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
