Answer / mukunda

Mapping structure
=================

source-->sq-->sequence-->exp-->router-->target1
|-->target2


1)Pass the seq genarator "nextval" port to expression.
2)through expression t/r pass the variable port to router
3)In router create two groups

Group1:nexval<=50-->this group conneted to target1
Groutp2:nexval>=50-->this group conneted to target2

or


default group connected to target2

Note: This logic only that source data contain 100 records.


If you any quires please ask.


Best Regards,

Mukunda
mukunda.velluri@gmail.com

Answer / balakrushna

Hi Mukunda,
U r correct but, y u are using addional t/r Exp, without
EXP we will make this mapping scenario,

I made it actually, that is the way i am sending this
like as follow

SQ-Gen-|
|
Source--> SQL------>RTR->Target1
|
|--->Target2

In SQ-Gen:
Change the Startvalue, Endvalue and Check the CYCLE and
RESET option in the properties of SQ-Gen
popuklate the NEXTVAL from Seq_gen to RTR.

In the RTR t/r:
(as my scnario the 3 records will load tgt1 and next 3 will
load in tgt2 and next 3 will load in again TGT1 and so on..)
2 groups
one is NEXTVAL <= 3
and NEXTVAL >= 4
and populated these groups to ur target accordingly.

Thanks & Regards
Balakrushna

Answer / kamleshmishra291

After SQ take expression and add port
v_Sequene=v_Sequence+1
o_Sequence=v_Sequence
Take Router Transformation and add two groups
Group1 = o_sequence<=50
Group2=o_sequence>50
Connect Group1 and Group2 to Target1 and Target2

can any one explain me about junk dimension

4 Answers  

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers   IBM,

---

Define filter transformation?

0 Answers  

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

---

On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records

1 Answers  

---

What is Cognos script editor?

0 Answers   Cognizant,

---

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,

---

what is scd?

6 Answers  

---

what is the -ve test case in your project.

0 Answers   CTS, TCS,

---

what is mapping performence?

2 Answers   Cap Gemini,

---

What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,

---