what is target update override and when we use it?
- 2 Answers
- 6056 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ankur saini er.ankur861@gmail.
Hi
Even if the table has key columns but as per some
requirement you dont want to update the records based on
that key column in this scnario also we can use update
overide to update the records based on our desired column
(s) other than primary index(td) or primary key(oracle)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we override a native sql query within informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
Write the unconnected lookup syntax and how to return more than one column.
How we can create indexes after completing the load process?
What is the function of union transformation?
Enlist some properties of sessions.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is a sorter transformation?
What is the need of etl tools?
What are the prerequisite tasks to achieve the session partition?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How many transformations can be used in mapplets.
What are the types of schemas we have in data warehouse.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
