What is the difference between Connected and UnConnected
Lookup Transformation.Give me one or two examples please?
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 do think which one is the better joiner or look up?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is the difference between informatics 7x and 8x and what is latest version?
Explain the pipeline partition with real time example?
Differences between version 7.x and 8.x.
Quickly characterize reusable change?
Define joiner transformation?
Define enterprise data warehousing?
How to do the error handling of if ur source is flatfiles?
Write the unconnected lookup syntax and how to return more than one column.
How to start a workflow using pmcmd command?
What all are steps in up gradation of Informatica server?
Define sessions in informatica etl?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Write the advantages of partitioning a session?