Interested to Buy Any Domain ? << Click Here >> for more details...
with out using update strategy transnsformation how to
update the data in mapping level
- 1 Answers
- 4907 Views
- I also Faced
- E-Mail Answers
Answer / guest
By using target update override and by using sessions
property treat source rows as update.by using this options
we can update the data
If any statement is wrong try to correct it
| Is This Answer Correct ? | 4 Yes | 0 No |
How can you increase the performance in joiner transformation?
What are the uses of a Parameter file?
what is system requirement(SR) & business requirement(BR)?
What is the reusable transformation?
What is confirmed dimension and fact?
generate Unique sequence numbers for each partition in session with Unconnected Lookup ? Hi All, Please help me to resolve the below issue while Applying partitioning concept to my Session. This is a very simple mapping with Source, Lookup , router, and target. I need to Lookup on the target and compare with the source data, if any piece of data is new then Insert, and If any thing change in the existed data then Update. while Inserting the new records to the target table I'm generating sequence numbers with Unconnected lookup, by calling the maximum PK ID from the target table. The above flow is working fine from last one year. Now I wish to apply the Partitioning concept to the above floe(session) At source I used 4 pass through partitions.(For Each partition different filter conditions to pull the data from source) at Target I used 4 passthrough Partitions. it is working fine for some data, but for some rows for Insert Operation , it is throwing Unique key errors, because while Inserting the data it is generating the same sequence key twice. In detail : 1st row is coming from 1st partition and generated the sequence number 1 for that row. 2nd row is coming from 1st partition and generated the sequence number 2 for that row 3rd row is coming from the 2nd partition generated the sequence number 2 again for that row. (it must generate 3 for this row) the issue is becuase of generating the same sequence numbers twice for different partitions. Can any one Please help me to resolve this issue. While Applying partitions how can I generate a Unique Sequence numbers from Unconnected lookup for Each partitioned data. Regrads, N Kiran.
Which transformation should u need while using the cobol sources as source defintions?
Different types of Power center errors?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
 Code page compatibly –Where all changes are made to handle the scenario.
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
How to compare Source and Target table, without using dynamic lookup?
Teradata 
