Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Experts , Can you please help me regarding the below
question How to remove first three rows and last three rows
in informatica.. thanks and regards Natraj
- 2 Answers
- 6531 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 8 Yes | 0 No |
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
| Is This Answer Correct ? | 3 Yes | 5 No |
What is different between informatica version 8 and 9 version
How u use pdf file in informatica source?
How to join three sources using joiner?
How do you handle decimal places while importing a flatfile into informatica?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
Can we get 1st record through Informatica(without sequence number).
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
what is lookup ?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
what is the function of 'F10' informatica ?
Teradata 
