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 are the guidelines to be followed while using union transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Explain Dataware house architecture .how data flow from intial to end?
Explain the code page compatibility?
How can we delete duplicate rows from flat files?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Is there any target staging area in informatica not staging area
While migrating the data from one environment to another environment how would you manage the connections?
How to generate sequence numbers using expression transformation?
How can we update a record in the target table without using update strategy?
How can informatica be used for an organization?
What are the uses of etl tools?
How to do unit testing in informatica? How to load data in informatica ?
What is a joiner transformation?
What are the tasks that can be performed using sq?
