LOOKUP Condition is nothing but a Join condition?
What type of join condition it,by default ?
Using the LookUP Condition How many types of relational
conditions we can make ?
Answer Posted / krithi
Using the Lookup Condition , we can only compare values
between two columns. If the data matches it returns the
default value and NULL if the data doesn't match.
We can compare using the following operators :
1) =
2)!=
3)< or <=
4)> or >=
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
which one is better performance wise joiner or look up
How do you load unique records into one target table and duplicate records into a different target table?
What are the components of workflow manager?
Is it possible to revert a global repository to local one and why?
What is the difference between source qualifier transformations source filter to filter transformation?
Why update strategy and union transformations are active? Explain with examples.
Could you explain what is enterprise data warehouse?
Can you use flat files in Mapplets.
Define filter transformation?
how to load dimension table and fact table. plz tell me the steps.
How to open an older version of an object in the workspace?
What's the layout of parameter file (what does a parameter file contain?)?
Why union transformation is an active transformation?
Explain the code page compatibility?