Answer / sehaj

PASS RECORDS FROM SOURCE QUALIFIER TO EXPRESSION.
CREATE A VARIABLE WITHA GGREGATION AS COUNT N ASSIGN ITS VALUE AS 0.
CREATE TWO PARAMETRES N ASSIGN DEM VALUES.
FIRST ONE 5
SECOND ONE 995
.
IN EXPRESSION CREATE AN OUTPUT PORT AS NUMBER DATATYPE N IN THE EXPRESSION EDITOR WRITE....
SEQUENCE=SETCOUNTVARIABLE(VARIABLE NAME U CREATED).

NOW
ATTACH IT TO THE ROUTER
CREATE A GROUP AND ENTER CONDITION
SEQUENCE>5 AND SEQUENCE<995
CONNECT THIS PORT TO TARGET...

SEHAJ....

Answer / lakshmi

source--->source qualifier--->sequencegenerator--->
exp--->router--->target.

Take nextval port and assign to exp

In router write condition below as
nextval>=5 and nextval<=995

copy all the ports from router to target

Answer / swathi

SOURCE->SQ->EXP->ROUTER->TARGET
After sq take seq or exp in exp using variable port concept create seq id like
v_count=count+1;
create output port assign variable port to output like
o_count=v_count
next take router and pass output port to router give condition
o_count>=5 and o_count<=985

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

---

replace multiple spaces with single space.

3 Answers   IBM,

---

explain about session partitions ?

1 Answers  

---

Define the various join types of joiner transformation?

0 Answers  

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,

---

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

---

Define joiner transformation?

0 Answers  

---

Can you access a repository created in previous version of Informatica?

1 Answers  

---

What are the two modes of datamovement in informatica sever?

2 Answers  

---

What is the function of aggregator transformation?

0 Answers  

---

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

0 Answers   Informatica,

---