Answer / susanta

Take a sequence generator with Start Value=1,Current
Value=1,End Value=3, Increment By=1 to assign a seqno to
each row. Do not forget to enable the cycle option.

after that take a Router with three groups of
seqno=1,seqno=2 and seqno=3.

Hope this will help u

Answer / ks316

Hi all,

I am posting my first post. Excuse me for any
mistakes, In the above answer given i dont think that the
target gets loaded in proper order. According to your
answer all the records gets loaded into all targets.

I think there should be a condition to every group in the
router.


i think the conditio should be like
mod(nextval,3)=0 tgt1
mod(nextval,3)=1 tgt2
mod(nextval,3)=2 tgt3,

pls correct me if i am wrong

Answer / avatar dss42b88

for this we use sequence generator t/r,
ex take source emp
targets -emp1,emp2,emp3.
mapping structure

sq->(seq)->exp->rtr->emp1(condition rowid=1)
->emp2(condition rowid=2)
->emp3(condition rowid=3)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like

start value=1
increment by=1
last value=3
currval=1
cycle check it save it.
execute mapping.

need for registering a repository server

1 Answers  

---

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,

---

What is a code page?

0 Answers  

---

What are the different threads in DTM process?

1 Answers  

---

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---

How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  

---

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.

2 Answers   Tech Mahindra,

---

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

---

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

---

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

---