Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / jagadish
update strategy transformation is used to perform DML
operations for the already data populated targets.
by default informatica server will treat source row as
INSERT.if you use update strategy transformation in your
mapping the informatica server will treat source row as
DATA DRIVEN.so the datas transferd to a target that even
populated with some data can be inserted,updated,rejected
and deleted.based upon the functions like
dd_insert,dd_update,dd_reject,dd_delete you define in the
update strategy transformation.
| Is This Answer Correct ? | 41 Yes | 3 No |
Post New Answer View All Answers
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
Write the program through which the records can be updated?
What is the advantage of informatica?
What if the source is a flat-file?
What are the settings that you use to configure the joiner transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain the different dimensions.
What is the difference between STOP and ABORT options in Workflow Monitor?
What is the function of aggregator transformation?
What is target load order?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is confirmed fact in dataware housing?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is rank index in rank transformation?
How can we improve session performance in aggregator transformation?
