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 / vivek
as per my understanding.. lkp is always behave like left
outer join..it ll give you all matched records as well as
ummatched records which is not present in base table...and
those unmatched records is ll be null in case of
unconnected lkp trn.....
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Enterprise data warehouse your projects phase by phase explain?
How an expression transformation differs from aggregator transformation?
What are the different ways to implement parallel processing in informatica?
What are the components of the workflow manager?
Do you find any difficulty while working with flat files as source and target?
Enlist some properties of sessions.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Informatica settings are available in which file?
How can we handle two sessions in informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Differentiate between a database and data warehouse?
Write the program through which the records can be updated?
waht type of interface is used for testing the data in informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are session parameters ? How do you set them?