which is better perfomancewise lookup or joiner and why?can anyone give example?
Answer Posted / 78swapnil
All you guys are correct. But there is a major difference between lookup and joiner is, when you join the table we need to join on the basis of a join condition (=) but in case of lookup you can get the data join conditions like (=,!=,<=,>=).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is standalone command task?
Which version configuration tool used in ur project?
What is exclusive and normal mode for repository services?
What is informatica powercenter repository?
how we can load rejected record's at run time?(not through bad files)
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Make a note of the quantity vaults made in informatica?
explain about unit testing? in real time?
which one is better performance wise joiner or look up
While migrating the data from one environment to another environment how would you manage the connections?
What are the different ways to implement parallel processing in informatica?
what is the -ve test case in your project.
what is the difference between informatica6.1 and infomatica7.1
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Is it possible to define a single node as a Gateway node as well as worker node?