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
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is the surrogate key?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What does cheating measurement mean?
expain about the tune parameters?
What is Cognos script editor?
What is domain in terms of informatica?
Global and Local shortcuts. Advantages.
Slowly changing dimensions, types and where will you use them
What is an expression transformation?
What does refresh system mean, and what are its distinctive choice?
Different circumstance which drives informatica server to expel records?
Differentiate between sessions and batches?
Explain what are the different versions of informatica?
