What is a diff between joiner and lookup transformation
Answer Posted / krishna
I) Joiner is active transformation & lookup is passive
transformation.
2)joiner having input port,output port, master port where as in lookup having input port, output port,lookup port,return port.
3) joiner having sorted inputs option where as lookup doesent have this option
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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 differs when we choose the sorted input for aggregator transformation?
Does an informatica transformation support only aggregate expressions?
What is the difference between a connected look up and unconnected lookup?
What is the difference between informatics 7x and 8x and what is latest version?
Why update strategy and union transformations are active?
What are the differences between joiner transformation and source qualifier transformation?
Explain the different lookup methods used in informatica?
How does a sorter cache works?
write a query to retrieve the latest records from the table sorted by version(scd)
What is the different lookup cache(s)?
server hot-ws270 is connect to Repository B. What does it mean?
What is confirmed fact in dataware housing?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Which transformation is needed while using the Cobol sources as source definitions?