Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95507 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / shiva shankar naidu n
1.Join supports all types of joins, but lookup supports only
two types of joins supports like inner and left outer only..
2.join not provided rejected link, but lookup provided it.
3.join is high sorting speed but not lookup.
4.join takes huge amount of data from two tables, but look
up not supported to data than source table.
5.In lookup Reference data always less than source data
other wise its not suppoted.
6.lookup always based on condition, but not join stage.
7.join common column must be same, in look up no need common
column name.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the surrogate key?
What is an aggregator transformation?
Reusable transformation and shortcut differences
How do you manage the Parameter files while migrating your data from one environment to another environment?
Can we override a native sql query within informatica?
Which transformation is needed while using the Cobol sources as source definitions?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How can we improve session performance in aggregator transformation?
What are mapplets? How is it different from a Reusable Transformation?
What is a passive transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How union transformation is used?
In informatica workflow manager, how many repositories can be created?
