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
- 6186 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the restrictions of union transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is an Integration service in Informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
generate date / time dimension in informatica
Define the various join types of joiner transformation?
Explain Dataware house architecture .how data flow from intial to end?
What is a pre-defined event and user-defined event?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
difference between informatica 8.1.1 and 8.6
What is an active transformation?
Explain lookup transformation in informatica
What is data caches/ index caches?
Define update strategy?
what is the size of u r source(like file or table)?
