differnece between joiner and a look up(please don't give
just definitions)....i mean in which scenario it is better
to use joiner and in which scenario better o use lookup ??
Answer Posted / guest
Lookup-
Let suppose you have empno in your source table but the
empno,address,name etc are stored in a lookup table and you
want all detail of employee will be go to target,then look
up is better option.
Lookup is passive transformation and support join on lookup
table basis of src.empno=lkp.empno(+).that means if in the
lookup table not have the source coming empno then it will
return null value for lookup empno.
so let suppose the lookup table is the target table in your
mapping,then you can find out the target table exists the
source record or not.
Joiner
If you want, the join condition satisfied,then the
satisfied all rows should go for next then join condition is
mandatory.Lookup can't do that.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are different types of transformations available in informatica?
Explain joiner transformation in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What do you understand by term role-playing dimension?
How to open an older version of an object in the workspace?
In development project what is the process to follow for an etl developer from day1
How many ways are there to create ports?
can you please explain me pre session and post session options?
Sequence generator, when you move from develoment to production how will you reset
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is a connected transformation?
Differentiate between a repository server and a powerhouse?
-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 is main use of mapplet?
What happens when a session fails and you click on recover?