What is diff joiner and lookup

Answer Posted / padmavathi

Joiner:
Can join herterogeneous sources.
Can join non-relational sources.
Can join partially transformed data.

Loopup:
Can reuse cache across session run.
Can reuse cache with mapping.
Can modify cache dynamically
Can query relational table or flat file.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there any way to read the ms excel datas directly into informatica?

546


What are the types of schemas we have in data warehouse.

526


How to improve the performance of a session using sorter transformation?

684


How to handle decimal places while importing a flatfile into informatica?

714


What all join we can perform in LOOKUP transformation?

559






How can we store previous session logs?

563


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1647


Explain load alternative records / rows into multiple targets - informatica

675


What is repository manager?

530


Define enterprise data warehousing?

630


Explain the etl program with few examples.

541


Does an informatica transformation support only aggregate expressions?

604


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3501


What are the basic requirements to join two sources in a source qualifier transformation using default join?

609


What differs when we choose the sorted input for aggregator transformation?

565