Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Experts,
Performance Wise Which transformation is better in LOOKUP
AND JOINER TRansformations? Why? Can anybody please explain
it ?
Please help me out from this Question.
Thanks In Advance.
- 2 Answers
- 13979 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / raj
the lookup and joiner t/r can be used to join two sources data.
if u r using one source is flat file and another source is database source then we can use joiner is better.i.e heterogeneous join.it is not possible with the help of lookup.
if two sources are in the same database lookup is better.
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
What is lookup transformation?
Explain the aggregator transformation?
What is the cumulative sum and moving sum?
How to handle decimal places while importing a flatfile into informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is enterprise data warehousing?
What is a rank transform?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the different lookup cache(s)?
Explain the mapping variable usage example in informatica
What is the difference between a connected look up and unconnected lookup?
Why is sorter an active transformation?
server hot-ws270 is connect to Repository B. What does it mean?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
