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.
- 2 Answers
- 13028 Views
- CTS, I also Faced
- E-Mail Answers
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
What is workflow monitor?
What is the format of informatica objects in a repository?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How union transformation is used?
Can we create two repositories on same database instance in oracle?
How can you validate all mappings in the repository simultaneously?
How to join three sources using joiner?
Enlist the differences between database and data warehouse.
Explain target update override in informatica
Does an informatica transformation support only aggregate expressions?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is a grid in Informatica?
how to create user defined function (udf) in informatica
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How to generate sequence numbers without using the sequence generator transformation?
