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
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the function of look up transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the difference between informatics 7x and 8x and what is latest version?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain the types of lookup transformation?
What are the components of the workflow manager?
update strategy transformation in informatica
my source is junk data how will u remove that junk data by using unix please any one replay me
where to store informatica rejected data? How to extract the informatica rejected data?
What is depict expression change?
Can we create a Integration service without a Repository service and vice versa?
What is dimensional table? Explain the different dimensions.
How does a sorter cache works?
Mention few advantages of router transformation over filter transformation.
