Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
5 11046generate 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.
2 71431)how many tr's you have moved in support project? 2)tell me the complete process of idoc's? 3)what are the interfaces you have dealt wih in your project?
2062How to procure 2 laptops of the same quality with 2 different prices to 2 different plants p1 and p2 of the same company? How will you map this process using SAP MM?
3 12662Post New Tech Mahindra Interview Questions
Can you buy just microsoft word?
how can i see junk values in dclgen or in hostvariable of comp ?
I want to prepare a frequency generator. the specifications i.e. output requirements are 12V, 1-10A & frequency upto 1K to 5K. Please, inform me with proper circuit dig. & the component values.
Who created the Python programming language?
What do you understand by the concept of a 6 stroke engine?
What is the difference between taskbot, metabot and iqbot in rpa tool?
If concern supply garments from outside purchase to movie producer for their production then is it maintain Service Tax if yes then how and at first what steps I have to take?
I used Etabs software to analyse a high-rise building. And I want to use templated UBC-codes inside to calculate the Seismic load. My question is: whether or not I have to control the seismic load by base shear load which is manual calculation? (just for more clarification: I can control this by input the scale factor into Eartquake definition in Etabs) I would highly appreciate your answer.
How can one interpolate variables or dynamic variable names?
Can we have two main methods in a java class?
What is a function word example?
What is a Smart Card or Chip Card or Integrated Circuit Card (ICC)?
What is the difference between level 1 and level 2 cache?
Why I/P transducer is connect with 24V DC not to 220V AC?
Explain About Openpages Policy And Compliance Management ?