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 / kalyan
Yes, Lookup Condition means is join COndition...By default,
it will give Normal joins..The different types of Join
conditions are =,!=,<,<=,>,>=
Please correct if I am wrong...
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
What are the advantages of using informatica as an etl tool over teradata?
What is aggregate cache in aggregator transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is the scenario which compels informatica server to reject files?
Explain the tuning lookup transformation - informatica
Scheduling properties,whats the default (sequential)
where to store informatica rejected data? How to extract the informatica rejected data?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is a snowflake schema?
How can a transformation be made reusable?
What are the types of lookup transformation?
What is meant by LDAP users?
While importing the relational source definition from the database, what are the metadata of source that will be imported?