What is a diff between joiner and lookup transformation
Answer Posted / kalpana
joiner doesnt support nonequi joins where as lookup support
nonequijoin
| Is This Answer Correct ? | 73 Yes | 12 No |
Post New Answer View All Answers
How to create the source and target database connections in server manager?
What is a joiner transformation?
Explain sessions and how many types of sessions are there?
What is a router transformation?
What is native users?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the settings that you use to configure the joiner transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the session task and command task?
Partition, what happens if the specified key range is shorter and longer
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to improve the performance of a session using sorter transformation?
Define the various join types of joiner transformation?
how to load dimension table and fact table. plz tell me the steps.
Make a note of the quantity vaults made in informatica?