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
- 6752 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
Explain your project of banking domian.
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is sequence generator transformation in informatica?
Explain about Informatica server process that how it works relates to mapping variables?
explain about unit testing? in real time?
What are the different types of repositories created using informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to partition the Session?
Explain in detail about scd type 1 through mapping.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How can we improve session performance in aggregator transformation?
Separate from a database, an information bazaar, and an information stockroom?
How to do unit testing in informatica? How to load data in informatica ?
What is confirmed fact in dataware housing?
what is the complex transformation you used in informatica
