WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
- 7 Answers
- 33147 Views
- Target, I also Faced
- E-Mail Answers
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 aggregate cache in aggregator transformation?
Explain your project of banking domian.
What is xml source qualifier transformation in informatica?
What is a pre-defined event and user-defined event?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is a joiner transformation?
What is the sequence generator transformation in informatica?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Tell me about Propagate functions in informatica
How to partition the Session?
Did u used latest transformations of 8.6.0? for what?
What is mapplet in informatica?
What is the meaning of up gradation of repository?
