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
What are the steps involved in the migration from older version to newer version of Informatica Server?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is native users?
I have a flat file, want to reverse the contents of the flat file
What are the modules in Power Center
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the difference between a connected look up and unconnected lookup?
What is the use of source qualifier?
What's the layout of parameter file (what does a parameter file contain?)?
Define sessions in informatica etl?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Explain the different kinds of facts.
Which files are created during the session rums by informatics server?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the function of look up transformation?