Answer Posted / rekha
CONNECT LOOKUP IT INVOVES IN A MAPPING PIPELINE. IT
RECEIVES MULTIPLE INPUTS AND PROVIDES NULTIPLE OUTPUT.
SUPPORTS USER DEFINED VALUES
DYNAMIC CACHE
UNCONNECTED: IT DOES NOT INVOLVE IN A MAPPING PIPELINE. IT
IS CONNECTED FROM THE RESULT OF :LKP() EXPRESSION IN
ANOTHER TRANSFORMATION
IT RECEIVES MULTIPLE INPUTS AND PROVIDE A SINGLE OUTPUT
THAT IS RETURN PORT
IT DOES NOT SUPPORT USER DEFINED VALUES
STATIC CACHE
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different options available for update strategy?
Define mapping and session?
How to partition the Session?
What is a repository? And how to add it in an informatica client?
How we can use union transformation?
What is expression transformation?
What is the need for an etl tool?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Did u used latest transformations of 8.6.0? for what?
What is meant by lookup transformation?
What is the Rank index port in Rank transformation?
What is the way to execute pl/sql script using informatica mapping?
what is the size of your data warehousing?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain in detail about scd type 1 through mapping.