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
What is the need of etl tools?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is an Integration service in Informatica?
What if the source is a flat-file?
How to load the data from people soft hrm to people soft erm using informatica?
how tokens will generate?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
To import the flat file definition into the designer where should the flat file be placed?
Write the different tools in the workflow manager?
What is a difference between complete, stop and abort?
What are the types of caches in lookup?
What is a surrogate key?
How to convert multiple rows to single row (multiple columns) in informatica
Informatica Checkpoints
What is a sequence generator transformation?