Answer Posted / akash

I can suggest 2 ways of obtaining the results:

1. Through source qualifier, filter and sequence generator:
From source qualifier get the total records count in one
port, say record_count and from sequence generator add an
input port, say record_number.

In the filter add the condition:
(record_number > 3) AND (record_number < (record_count - 2))

2. Using the following sql query: (not sure about the
results. Please confirm the same and suggest any updates if
required):

select key_field, DESCRIPTION from temp_table
where
ROWID NOT IN (SELECT ROWID FROM TEMP_TABLE WHERE ROWNUM <=
3)
AND ROWID IN (SELECT ROWID FROM TEMP_TABLE WHERE ROWNUM <=
(SELECT COUNT(*) FROM TEMP_TABLE) - 3)

In the above query temp_table is the table name, key_field
and Description are column names.

Which are the different editions of informatica powercenter that are available?

993

---

How to handle decimal places while importing a flatfile into informatica?

1150

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1914

---

Informatica settings are available in which file?

951

---

Do you find any difficulty while working with flat files as source and target?

1066

---

what is Active lock explain

2749

---

Explain direct and indirect flat file loading (source file type) - informatica

1285

---

What is target load order?

1205

---

tell me 5 session failure in real time how can you solve that in your project?

2220

---

can we override a native sql query within informatica? How do we do it?

1078

---

What is workflow manager?

1008

---

Differentiate between sessions and batches?

979

---

Clarify the aggregator change?

993

---

difference between informatica 8.1.1 and 8.6

3644

---

How union transformation is used?

971

---