Hi Experts,
Performance Wise Which transformation is better in LOOKUP
AND JOINER TRansformations? Why? Can anybody please explain
it ?
Please help me out from this Question.
Thanks In Advance.
Answer Posted / raj
the lookup and joiner t/r can be used to join two sources data.
if u r using one source is flat file and another source is database source then we can use joiner is better.i.e heterogeneous join.it is not possible with the help of lookup.
if two sources are in the same database lookup is better.
Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
Explain how many types of dimensions are available in informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What do you mean incremental aggregation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
is it possible to index the data in cache of lkp transformation ?
How to update source definition?
r u done any partitions in ur project?
What is a sorter transformation?
Separate from a database, an information bazaar, and an information stockroom?
In warehouses how many schemas are there?
What is data movement mode in Informatica and difference between them?
What do you understand by term role-playing dimension?
How to elaborate tracing level?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is mapping debugger?