Interested to Buy Any Domain ? << Click Here >> for more details...
How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
- 6 Answers
- 15064 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / abhinav
By using an UPDATE STARTEGY transformation.
DD_UPDATE = If the record alreadye exists
DD_INSERT = If the record is a new one
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How do you load unique records into one target table and duplicate records into a different target table?
Performance tuning( what you did in performance tuning)
waht type of interface is used for testing the data in informatica
What are the designer tools for creating transformations?
How are indexes created after completing the load process?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is the way to execute pl/sql script using informatica mapping?
What is a node in Informatica?
What is exclusive and normal mode for repository services?
What is the surrogate key?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain target update override in informatica
State the differences between sql override and lookup override?
What is data movement mode in Informatica and difference between them?
What is informatica powercenter repository?
