Answer / sajid hussain

Step1: After SQ transformation take Sequence Generator transformation and edit properties like, Start Value=1, Increment By=1, End Value=3 and check the Cycle.

Step2: Now take a Router transformation and drag all the ports from SQ transformation to Router, as well as drag the NEXT VAL port from Sequence Generator transformation to Router.

Step3: Create 3 group T1, T2 and T3 and for each group condition will be like T1 --> NEXTVAL=1, T2 --> NEXTVAL=2 and T3 --> NEXTVAL=3

Step4: Connect all the 3 targets and run the mapping.

Answer / naveenkumar

drag and drop the source to the mapping and connect the expression transformation.variable port to an expression transformation
v_count=v_count+1
o_count=v_count
and exp transformation to connect the router transformation groups
column name<=25 lks
column name>=26 lks and column name<=50 lks
column name>=51 lks and column name<=75 lks
column name>=76 lks and column name <=1 cros

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

---

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

---

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,

---

how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,

---

What is native users?

0 Answers  

---

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

---

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

---

which one is better either active or passive transformation in informatica

1 Answers  

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

---

What is a test load?

1 Answers  

---

Differentiate between sessions and batches?

0 Answers  

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---