which is better perfomancewise lookup or joiner and why?can anyone give example?
Answer Posted / lokesh.t
lookup is having multiple advantages compare to joiner
transformations :-it will avoid duplicate vlues . by
using first last value in lkp values . with lkp we can n
nnumber of tables. where as in joiner we can join only
two tables
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is parallel processing in informatica?
What is a mapplet/worklet in informatica?
can anyone explain me about retail domain project in informatica?
What are the transformations that are not supported in mapplet?
How to elaborate powercenter integration service?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is the function of union transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain pushdown optimization and types in informatica
What are the uses of etl tools?
How do you change a non-reusable transformation to reusable transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
what is the size of your data warehousing?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is decode in static cache?