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
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 pushdown optimization $pushdownconfig parameter - informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the different types of olap? Give an example?
What is the need for an etl tool?
how to load dimension table and fact table. plz tell me the steps.
What is standalone command task?
How can we delete duplicate rows from flat files?
How many numbers of sessions can one group in batches?
Briefly define reusable transformation?
Global and Local shortcuts. Advantages.
Is it possible to use a client with different version than that of its Informatica server?
Is it possible to revert a global repository to local one and why?
Tell me about MD5 functions in informatica
What does refresh system mean, and what are its distinctive choice?
What are the advantages of using informatica as an etl tool over teradata?