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.

Where is metadata stored?

1096

---

Write the prerequisite tasks to achieve the session partition?

1129

---

How you prepared reports for OLAP?

1586

---

How would you join a node to the already existing domain?

1110

---

What are the modules in Power Center

1666

---

Explain the difference between mapping parameter and mapping variable?

1020

---

Different qualification between a related rotate toward the sky and isolates look upward?

975

---

What is meant by a domain?

1110

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2017

---

What are the different versions of informatica?

1246

---

Which transformation is needed while using the Cobol sources as source definitions?

1157

---

Is it possible to define a single node as a Gateway node as well as worker node?

1105

---

Explain incremental aggregation in informatica

1109

---

What is parallel processing in informatica?

1687

---

Explain the types of transformations?

1050

---