WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
- 7 Answers
- 32040 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
how many types of dimensions are available in informatica?
Write the prerequisite tasks to achieve the session partition?
State the limitations where we cannot use joiner in the mapping pipeline?
What is the use of an aggregator cache file?
Explain pushdown optimization $pushdownconfig parameter - informatica
explan ur project architecture?
How to update a particular record in target with out running whole workflow?
State the differences between sql override and lookup override?
Suppose we do not group by on any ports of the aggregator what will be the output?
what is degenerated dimension?
how we can load rejected record's at run time?(not through bad files)
What are the different types of repositories created using informatica?
What the difference is between a database, a data warehouse and a data mart?
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
Enlist the advantages of informatica.
