Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 6 Answers
- 22689 Views
- I also Faced
- E-Mail Answers
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 an expression transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How do you take back up of repository?
What are ETL Tools?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is data movement mode in Informatica and difference between them?
How we can create indexes after completing the load process?
How can you generate reports in informatica?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How can one identify whether mapping is correct or not without connecting session?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
permutations of mapplet
What is the difference between writing a joiner query in ANSI style and THETA style?
Difference between Data and Index Caches?
