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
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 |
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is confirmed dimension and fact?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
what is scd?
What is depict expression change?
which is better perfomancewise lookup or joiner and why?can anyone give example?
Make a note of the quantity vaults made in informatica?
Define mapplet?
Can you copy the session to a different folder or repository?
How to improve the performance of a session using sorter transformation?
What are the limitations of joiner transformation?
what is session override?