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
Design a mapping to load a target table with the following values from the above source?
How to update or delete the rows in a target, which do not have key fields?
Enlist few areas or real-time situations where informatica is required.
How can you define user defied event?
How can we remove the duplicates from flat file source?
What is data caches/ index caches?
is it possible to index the data in cache of lkp transformation ?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What do you mean by blocking transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Explain what is informatica metadata and where is it stored?
how to create user defined function (udf) in informatica
What differs when we choose the sorted input for aggregator transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?