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

How to delete duplicate records in a flat file source?

2 Answers  

---

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---

how i will stop my workflow after 10 errors

2 Answers   HP,

---

How do you use reject loader.

0 Answers  

---

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,

---

---

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,

---

What is polling in informatica ?

1 Answers   TCS,

---

how to obtain performance data for individual transformations.

2 Answers  

---

How to extract the informatica rejected data?

0 Answers  

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers  

---

Explain joiner transformation in informatica

0 Answers   Informatica,

---

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---