Answer Posted / 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....

where to store informatica rejected data?

1093

---

What is the advantage of informatica?

1069

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2122

---

Global and Local shortcuts. Advantages.

2034

---

What is decode in informatica?

1162

---

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?

6490

---

What is a node in Informatica?

1041

---

what is $$$$?

2157

---

Explain in detail scd type 2 through mapping.

1041

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2261

---

Enlist the tasks for which source qualifier transformation is used.

1040

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1322

---

Explain transaction control transformation in informatica

1268

---

What is status code in informatica?

1020

---

Explain lookup transformation in informatica

1073

---