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

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

what is bridge tables in informatica

1 Answers   CTS,

---

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,

---

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

---

whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,

---

---

What is a passive transformation?

0 Answers   Informatica,

---

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

---

What are data-driven sessions?

0 Answers  

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

What is informatica worklet?

0 Answers  

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,

---