What is a diff between joiner and lookup transformation
- 16 Answers
- 90846 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / mythili
Hi everybody,
Joiner is active transformation whereas lookup is passive
transformation.
Joiner returns only matching records whereas lookup
returns null if there is no match.
In join condition we can give only '=' operator but in
lookup condition !=,>=,<= are all possible.
Joiner will do left outer,right outer,normal,full outer
type of joins whereas lookup will do only left outer join.
| Is This Answer Correct ? | 31 Yes | 9 No |
Post New Answer View All Answers
What is a grid in Informatica?
How you prepared reports for OLAP?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How can informatica be used for an organization?
What do you understand by term role-playing dimension?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
r u done any partitions in ur project?
What is union 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?
What is the function of look up transformation?
How to elaborate tracing level?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are the different types of repositories created using informatica?
Have you worked with/created Parameter file
Differentiate between reusable transformation and mapplet.
