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
Explain the pipeline partition with real time example?
How do you load unique records into one target table and duplicate records into a different target table?
Please let me know how to make Data masking in informatica..
Explain pushdown optimization and types in informatica
Define joiner transformation?
what is size of u r database?
What are mapplets? How is it different from a Reusable Transformation?
where to store informatica rejected data?
-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 is olap (on-line analytical processing?
Write the advantages of partitioning a session?
how to create user defined function (udf) in informatica
What is incremental aggregation?
Explain lookup transformation source types in informatica
permutations of mapplet