How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
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
wf dont have integration severances how you can run?
What is flashback table ? Advance thanks
Enlist the differences between database and data warehouse.
What are the main issues while working with flat files as source and as targets ?
Can we create multiple integration service on single repository?
What the difference is between a database, a data warehouse and a data mart?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the types of presistent cache in look up tr.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Which are the different editions of informatica powercenter that are available?
What is target load order?
How can we use mapping variables in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?