what is mean by flag 4 in update strategy t/r
Answers were Sorted based on User's Feedback
Answer / gyana
exactly
with out 0 1 2 3,if u enter any number then update_strategy t/r INSERT the record.....if you enter 10 dn also insert only
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sham
if we give any other value the integration service will
treat any other value as an INSERT.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / manjunath
in update strategy flag 4 means INSERT.
0 Insert
1 Update
2 Delete
3 Reject.
if we give any other value the integration service will
treat any other value as an INSERT.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / madhu
in update strategy t/r other than (0,1,2,3) what ever it may
be numeric integration service flags the row to insert.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / siva
There is no meaning for 4 in Update Strategy.
0 Insert
1 Update
2 Delete
3 Reject
| Is This Answer Correct ? | 2 Yes | 3 No |
I think Flag 4 means DD_REJECT. It wont send any records to
target.
If i wrong means please mail me at chandranmca2007@gmail.com
| Is This Answer Correct ? | 3 Yes | 5 No |
State the limitations where we cannot use joiner in the mapping pipeline?
What is an aggregator transformation? it is active why cant it be passive explain?
What is dynamic cache?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
What is sql query override? When did u use sql query override?
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
In Which scenario did u used Incremental loading?
What is informatica worklet?
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
what is the significance of newlookup port in dynamic look up
Could any one to tell Fact table Partitioning?