Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 96371 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 are data-driven sessions?
Why update strategy and union transformations are active?
What is depict expression change?
What is meant by query override?
Does an informatica transformation support only aggregate expressions?
update strategy transformation in informatica
my source is junk data how will u remove that junk data by using unix please any one replay me
Explain the types of transformations?
generate date / time dimension in informatica
During the running session, output files are created by informatica server. Enlist few of them.
Explain the etl program with few examples.
What is the use of an aggregator cache file?
How to load the data from people soft hrm to people soft erm using informatica?
What is joiner transformation?
Explain the difference between a data warehouse and a data mart?
