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
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the informatica performance improvement tips
permutations of mapplet
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is the difference between stop and abort in informatica
What are the types of data warehouses?
What is mapplet in informatica?
Explain the difference between a data warehouse and a data mart?
What happens when a session fails and you click on recover?
How to do unit testing in informatica? How to load data in informatica ?
How can you define user defied event?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How can we store previous session logs?
What is data caches/ index caches?
Differentiate between a database and data warehouse?