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....

server hot-ws270 is connect to Repository B. What does it mean?

2531

---

What is a rank transform?

1069

---

Briefly define reusable transformation?

1113

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2282

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1063

---

generate date / time dimension in informatica

1110

---

What does “tail –f” command do and what is its use as an Informatica admin.

1079

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10115

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1618

---

Have you worked with/created Parameter file

1648

---

What is the meaning of up gradation of repository?

1957

---

What is Data Caches size?

1072

---

How you can differentiate between connected lookup and unconnected lookup?

1045

---

What are the types of presistent cache in look up tr.

2042

---

What do you understand by SOA of Informatica?

963

---