When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
Answer Posted / rayudu
When we want to return multiple ports from a mapping we wil
use connected lookup.
An connected lookup returns only one port from the t/r. If
we want to use lookup multiple times in a mapping and if we
want to lookup data only when the condition is true we will
use unconnected lookup. (if we dont want to look up all the
records and only some records)
regards,
rayudu
Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Briefly explain the aggregator transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain the scenario which compels informatica server to reject files?
Explain transaction control transformation in informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is informatica etl tool?
Explain in detail scd type 2 through mapping.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to join three sources using joiner?
Define the various join types of joiner transformation?
What is a snowflake schema?
I have a flat file, want to reverse the contents of the flat file
what is the complex transformation you used in informatica
Explain what transformation and how many are there in informatica?
how to create user defined function (udf) in informatica