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
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How do you convert single row from source into three rows into target?
What is the difference between a connected look up and unconnected lookup?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is the sequence generator transformation in informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the uses of etl tools?
Define mapping and session?
How can we store previous session logs?
Enlist the various types of transformations.
What is the Process to creating lookup transformation in informatica
Can we override a native sql query within informatica?
what is size of u r database?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
what is $$$$?