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 are the issues you have faced in your project? How did you overcome those issues?
permutations of mapplet
How can we use mapping variables in informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Is it possible to use a client with different version than that of its Informatica server?
What is meant by lookup transformation?
What are active transformations.
Explain the informatica workflow?
What is an active transformation?
What are the components of workflow manager?
Can we create multiple integration service on single repository?
Enlist the various types of transformations.
What is the way to execute pl/sql script using informatica mapping?
How will the document be delivered to me?