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


Please Help Members By Posting Answers For Below Questions

How to call shell scripts from informatica?

752


What is option by which we can run all the sessions in a batch simultaneously?

870


What if the source is a flat-file?

816


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1545


What are the types of schemas we have in data warehouse.

722


What are ETL Tools?

847


What you know about transaction control transformation?

749


What is informatica?

872


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1663


Explain sessions and how many types of sessions are there?

787


Partition, what happens if the specified key range is shorter and longer

2214


What is update strategy transform?

798


How will the document be delivered to me?

812


Describe an informatica powercenter?

800


What are batches?

808