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
Explain the aggregator transformation?
How to generate sequence numbers without using the sequence generator transformation?
What are the main issues while working with flat files as source and as targets ?
What is the advantage of informatica?
What is mapplet in informatica?
What is an aggregator transformation?
Different sorts of metadata that stores in the storage facility?
Under which circumstances, informatica server creates reject files?
Explain direct and indirect flat file loading (source file type) - informatica
have u done any performance tuning? how u ll do?
Can anyone tell me the new features in Informatica 9 Version?
What is a mapplet/worklet in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the different types of transformation available in informatica.
