can v update d records in target using update stargey
without generationg primary key ? explain
Answer Posted / sreekanth
@nagaraju
above answer is perfect.
we can mark as PK in etl level even though field is not
a PK in DB level
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a dimensional model?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How can informatica be used for an organization?
explain abt ur project architecture?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is an aggregator transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain the difference between mapping parameter and mapping variable?
How does the aggregator transformation handle null values?
Differences between connected and unconnected lookup?
What is the way to execute pl/sql script using informatica mapping?
What is joiner change?
What is the difference between source qualifier transformations source filter to filter transformation?
How to delete duplicate row using informatica?