WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
Answer Posted / praveen kumar pendekanti
In the case of source qualifier when we use sql override
opition we will get query with our alias name and when we
user update transformation override when we enter update
override we will get column names with alias name
In update transformation order by clause is default that is
not in sql over ride(According to my knowledge)
If i am wrong plz correct me to my mail-id.....
Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is meant by incremental aggregation?
Can we create two repositories on same database instance in oracle?
Explain the etl program with few examples.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to extract sap data using informatica?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Describe the impact of several join conditions and join order in a joiner transformation?
What are the new features of Power Center 5.0?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How do you use reject loader.
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.
Why union transformation is an active transformation?
What is transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project