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

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

---

How to partition the Session?

0 Answers   Informatica,

---

what is constraint based load order

2 Answers   Cap Gemini,

---

Explain the pipeline partition with real time example?

0 Answers   Informatica,

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

---

What are the types of error logs available in Informatica?

1 Answers  

---

Explain the shared cache and re-cache?

0 Answers  

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---

enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,

---

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  

---