Interested to Buy Any Domain ? << Click Here >> for more details...
Can we insert and update a target table without using update
strategy transformation?How?
- 4 Answers
- 23559 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / sreedhar lokaray
Yes you can insert or update a table without using update
strategy. In the Mapping tab of the Session property go to
Target properties and check the attribute value Insert to
insert or check Update as Update to update.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the informatica performance improvement tips
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
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
Clarify the aggregator change?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the measure objects?
What do you mean by blocking transformation?
Mention some types of transformation?
What is the function of aggregator transformation?
What do you mean by enterprise data warehousing?
In how many ways we can create ports?
What are the transformations that are not supported in mapplet?
What is data movement mode in Informatica and difference between them?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is the meaning of decode in informatica?
