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.

Explain in detail about scd type 1 through mapping.

1555

---

expain about the tune parameters?

2414

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2168

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

---

Sequence generator, when you move from develoment to production how will you reset

2040

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8223

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1963

---

What is the benefit of partitioning a session?

1182

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1108

---

Difference between Data and Index Caches?

1138

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

1079

---

differences between service based and product based?

2015

---

What does role playing dimension mean?

1044

---