Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 96366 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
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
How to create a non-reusable instance of reusable transformations?
Scheduling properties,whats the default (sequential)
How might one distinguish in the case of mapping is right or not without associating session?
What is workflow manager?
What is rank transform?
How can a transformation be made reusable?
Explain what are the different versions of informatica?
How do you set a varible in incremental aggregation
Explain what is informatica metadata and where is it stored?
What are mapplets? How is it different from a Reusable Transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Enlist some properties of sessions.
Explain the etl program with few examples.
What is a node in Informatica?
