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

Answer / rampriya

To skip first n of lines,

If source is DB, then use
select * from emp_details where rownum>3

If the source is flat file, then set Number of Initial lines
to skip=3 in session level property

what is semi-additive fact?where did u used?

2 Answers  

---

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

---

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

What is substr in informatica?

0 Answers  

---

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

---

How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,

---

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  

---

How to partition the Session?

0 Answers   Informatica,

---

Useful UNIX commands regular/frequently used

1 Answers   Deloitte,

---

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,

---

what is lookupoverriding?

1 Answers  

---