Answer Posted / mansi
We can override the lookup query for a relational lookup.
We can enter the entire override, or we can generate and
edit the default SQL statement.
Override the lookup query in the following circumstances:
1.Override the ORDER BY statement
2.A lookup table name or column names contains a reserved
word
3.Use mapping parameters and variables
4.A lookup column name contains a slash (/) character
5.Add a WHERE statement
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
In which transformation you cannot drag ports into it?
How do you convert single row from source into three rows into target?
What are the types of caches in lookup?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What could be the possible resons of locks by user?
How identifying bottlenecks in various components of informatica and resolving them?
What are active and passive transformations?
What does reusable transformation mean?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are the different types of repositories created using informatica?
Explain about Informatica server process that how it works relates to mapping variables?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain the types of transformations?
How to configure mapping in informatica?
