what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).
Answer Posted / akash
In addition to Kondeti's points:
1. With look up we have an option to match the data
dynamically if we use dynamic lookup.
2. If the match is not found may or may not send the record
(depending upon the joiner condition) but in case of look
up the output will be returned as default value or NULL for
every record where match is not found.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What do you understand by a term domain?
What is different between the data warehouse and data mart?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the benefit of partitioning a session?
what is SDLC way of code development?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Explain how to import oracle sequence into informatica?
What are the various types of transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the maplet?
what is the complex transformation you used in informatica
which one is better performance wise joiner or look up
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is lookup transformation?