Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
- 7 Answers
- 34551 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / ram reddy
Update Override it is an option available in TARGET
instance.By defalut Target table is updated based on
Primary key values.To update the Target table on non
primary key values u can generate the default Querey and
override the Querey according to the requiremnet.Suppose
for example u want to update the record in target table
When a column value='AAA' then u can include this condition
in where clause of default Querey.
Coming to SQL override it is an option available in Source
Qualifier and Lookup transafornmation where u can inlude
joins ,filters,Group by and order by.
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
What is the difference between STOP and ABORT options in Workflow Monitor?
How to delete duplicate row using informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Differentiate between router and filter transformation?
What are the different types of olap? Give an example?
difference between repository database and repository service?
Which files are created during the session rums by informatics server?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to load last n records of file into target table - informatica
Implementation methodology
What are the transformations that are not supported in mapplet?
What is a predefined event?
What is dimensional table? Explain the different dimensions.
What does role playing dimension mean?
