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 we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  

---

how to declare array in plsql?

1 Answers  

---

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,

---

In development project what is the process to follow for an etl developer from day1

0 Answers  

---

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

---

what is correlated query?

2 Answers   IBM,

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

What is sql query override? When did u use sql query override?

1 Answers   TCS,

---

Diff b/w ShortCut and reusabel Object ?

4 Answers  

---

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---