What is a diff between joiner and lookup transformation
Answer Posted / chandra
Joiner will join the two different data sources based on a
join condition ,and pass only the rows which satisfy that
condition.discards the remaining rows.
Joiner transformation supports 4 types of joins at
Informatica level
Normal
Master Outer
Detail Outer
Full Outer
LookUp Transformation
Lookup transformation basically for Reference,based on the
lookup condition.when u want some data based on target
data ,will take lookup on that particular table and
retrieve the corresponding fields from that table.
we can override the lookup transformation using the SQL
query.
Is This Answer Correct ? | 72 Yes | 19 No |
Post New Answer View All Answers
What is a node in Informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is a snowflake schema?
Explain the scenario which compels informatica server to reject files?
Explain informatica architecture - version 8 / 9
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Mention a few design and development best practices for informatica?
What is joiner change?
Define update strategy?
Where is metadata stored?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what are the deliverables?in your project?
What is dynamic cache?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?