Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between lookupoveride and joiner?
- 3 Answers
- 7837 Views
- I also Faced
- E-Mail Answers
Answer Posted / kotesh
using lookup override we can join more two table either it
is relational or flatfiles also. and one more advantage is
it supports orderby condition.
but jointrns we can join two tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What all are steps in up gradation of Informatica server?
permutations of mapplet
what are the Methods For Creating Reusable Transformations?
What are the different versions of informatica?
which one is better performance wise joiner or look up
Explain the different kinds of facts.
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What are the different types of olap? Give an example?
State the limitations where we cannot use joiner in the mapping pipeline?
What is domain and gateway node?
How many ways are there to do 'remove duplicate records in informatica'?
What is the commit type if you have a transaction control transformation in the mapping?
What is a grid in Informatica?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
