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
- 6529 Views
- I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Describe data concatenation?
what is song in infrmatica...?
What is complex mapping?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are some examples of informatica etl programs?
Why is sorter an active transformation?
What are the advantages of using informatica as an etl tool over teradata?
what is size of u r database?
Global and Local shortcuts. Advantages.
What is workflow manager?
Describe expression transformation?
What are the differences between oltp and olap?
How to elaborate tracing level?
What is expression transformation?
