Interested to Buy Any Domain ? << Click Here >> for more details...
what is the necessity to use update strategy?(except for
updates)
- 2 Answers
- 6254 Views
- Emphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gazulas
man!! u can flag the record as insert or reject.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / raghav
Following options are available for update strategy :
DD_INSERT : If this is used the Update Strategy flags the row for insertion. Equivalent numeric value of DD_INSERT is 0.
DD_UPDATE : If this is used the Update Strategy flags the row for update. Equivalent numeric value of DD_UPDATE is 1.
DD_DELETE : If this is used the Update Strategy flags the row for deletion. Equivalent numeric value of DD_DELETE is 2.
DD_REJECT : If this is used the Update Strategy flags the row for rejection. Equivalent numeric value of DD_REJECT is 3.
so u can use update strategy for delete, reject or insert.
| Is This Answer Correct ? | 0 Yes | 0 No |
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
guys which is the best institute in banglore to learn informatica??
What are the types of lookup?
what is incremantal aggregation?
Which one is better performance wise connected/un-connected lkp?why?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
What is xml source qualifier transformation in informatica?
What is parallel processing in informatica?
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
when will we go for unconnected lookup transformation in Informatica?
Teradata 
