What is a diff between joiner and lookup transformation
- 16 Answers
- 90969 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
hi, everyone.
lookup is passive whereas is joiner is active.
look up supports non equi joins ilso whereas joiner
supports only equi joins.
lookup joins on either on first value or last value.
lookup uses dynamic and static cache where as a joiner
doesnt
reach me on bsrinivas1213@gmail.com
| Is This Answer Correct ? | 22 Yes | 11 No |
Post New Answer View All Answers
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is rank transform?
What is the difference between router and filter?
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?
How to convert multiple rows to single row (multiple columns) in informatica
In how many ways we can create ports?
can anyone explain me about retail domain project in informatica?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Differentiate between router and filter transformation?
What is dimensional table?
What are the transformations that are not supported in mapplet?
Enlist the differences between database and data warehouse.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What do you mean by enterprise data warehousing?
