what is the difference between look up and joiner(don't say
joiner sopport only = where as look up support non-equijoin).
- 3 Answers
- 9040 Views
- IBM, ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / v.ramakrishna
both lookup and joiner transfromations are used to
horizantal merging . But lookup transformation can be
treated as paasive transformation where as joiner trans can
be treated as active transfr bcoz no of records input to
joiner will vary with output records. But in Lookup
transformation even though it searches for each record in
lookup if condition satisfied it will come as output even
condition not satisfied also , in that case it returns null
valu so no of records input to lookup is equal with outputs
due to null values this is the major diff between joiner
and lookup according to me.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between STOP and ABORT options in Workflow Monitor?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Where is metadata stored?
Do you find any difficulty while working with flat files as source and target?
Can we get 1st record through Informatica(without sequence number).
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
I have a flat file, want to reverse the contents of the flat file
What are pre and post-session shell commands?
What is workflow monitor?
How might you approve all mappings in the archive all the while?
What is the meaning of up gradation of repository?
What is the difference between writing a joiner query in ANSI style and THETA style?
Write the prerequisite tasks to achieve the session partition?
