Interested to Buy Any Domain ? << Click Here >> for more details...
which is better perfomancewise lookup or joiner and why?can anyone give example?
- 6 Answers
- 11986 Views
- TCS, I also Faced
- E-Mail Answers
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
How can you generate reports in informatica?
How can we remove the duplicates from flat file source?
What is the function of aggregator transformation?
What are the types of caches in lookup? Explain them.
What is workflow? What are the components of the workflow manager?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
To import the flat file definition into the designer where should the flat file be placed?
Mention some types of transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
what is Active lock explain
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Explain why we use partitioning the session in informatica?
What is informatica etl tool?
What are the mapping parameters and mapping variables?
State the limitations where we cannot use joiner in the mapping pipeline?
