Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is a sorter transformation?
What is primary and backup node?
What are the settings that you use to configure the joiner transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
is it possible to index the data in cache of lkp transformation ?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Under what condition selecting sorted input in aggregator may fail the session?
Explain target update override in informatica
What is meant by lookup transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain scd type 3 through mapping.
Explain what are the different types of transformation available in informatica.
How many numbers of sessions can one group in batches?
What are connected or unconnected transformations?
