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 song in infrmatica...?
What is a surrogate key?
What is a predefined event?
What is primary and backup node?
What are the types of data warehouses?
What does cheating measurement mean?
Separate from a database, an information bazaar, and an information stockroom?
How might one distinguish in the case of mapping is right or not without associating session?
What are the measure objects?
how many types of dimensions are available in informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is depict expression change?
Define pmcmd command?
is it possible to index the data in cache of lkp transformation ?
without table how to come first record only in oracle?