what is lookupoverriding?
Answer / 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 |
What are the unsupported repository objects for a mapplet?
What are the mapping paramaters and mapping variables?
Have you worked with/created Parameter file
What are the reusable transforamtions?
What do you mean incremental aggregation?
What are the designer tools for creating transformations?
how many types transformations supported by sortedinput?
In which circumstances that informatica server creates Reject files?
how to insert header after each group.
Can yoU use the maping parameters or variables created in one maping into another maping?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?