Interested to Buy Any Domain ? << Click Here >> for more details...
Performance wise which is better joiner or look up ?
Give me with example?
- 1 Answers
- 11252 Views
- CGI, I also Faced
- E-Mail Answers
Answer / abhinaw prakash
There is no definite answer to this.But if we are using
homogenous data sources its better to use Look up rather
than joiner.
Again Look up can only perform left outer join.So for other
Join we have to use Joiner.
| Is This Answer Correct ? | 3 Yes | 3 No |
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
Explain the difference between mapping parameter and mapping variable?
What are the differences between oltp and olap?
what are the settiings that u use to cofigure the joiner transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
how can one come to know wether the records loak into the target if we use update strategy
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain the different kinds of facts.
Why do we need informatica?
how to duplicates from expression transformation without using sorter before that
Can we change Dynamic to Static or Persistent cache? If so what happens?
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
Teradata 
